Programming

Insert a custom function in a cell by runnig a sub or through a macro.
I have a function named mysub and with parameters that has to be supplied to the function. I want that when the cell where the function is to be inserted, the user can type the arguments of the function sub after they have run the sub. Lets say, that after the sub is run, they get =mysub(..) with the cursor in... 15 May 2010 08:17

Windows update
Hi all I plan to fix the code at the link below and use it to audit and analyze windows updates on a large fleet of laptops (around 1000). http://www.vbaexpress.com/kb/getarticle.php?kb_id=806 My plan is to store everything in a table but it would be nice to retain raw data each time a laptop is audited (r... 15 May 2010 21:23

Call random UserForm from list
I have 9 different UserForms and I can call any specific UserForm with the macro below. (Imagine any number where the question mark is) Sub ShowUserForm() UserForm?.Show End Sub What I would like to do instead is have a macro that will call a different random UserForm from this list below each time I activ... 15 May 2010 14:50

Save a backup file
I have a file that I update each day and then it is updated by others. (Not a shared file) Everyday I open and run my code to pull in yesterdays updates. Before I pull in the updates I want to save a copy, "backup" in the same path on the server where the original file is located. I have tried various attempts whic... 17 May 2010 13:33

Count Unique Combinations
Hello all, I'm having problems coming up with a formula to count the number of unique combinations in a list. I have a list of people in column B and a list of tasks in column C. There are duplicates in both columns. I need a formula to count the unique combinations in the list (i.e. bob smith/j. smith would cou... 15 May 2010 13:44

pasting of variable cell value into macro
I have written a macro that runs an autofilter which grabs cell info from a different worksheet within that workbook (an entered date). It then uses that date to autofilter. It works fine the first time, but aparently plugs that info permanently into the macro and will not work on subsequent runs. I need a mac... 14 May 2010 19:26

copy a from a cell to another with desired format
hi all i need to make this copy.. aWS.Range("L80").Value = aWS.Range("J80").Value but with format with 4 decimals... can anybody help ? tx! paolo ... 14 May 2010 18:20

Calendar stuff
I have a need to create a calendar form with a few conditions. If the 2nd Tuesday of the month falls in this week, Highlight the entire week in RED. the next week in the month Highlight this week in Yellow, and finally if it's the 2nd week after the 2nd Tuesday Highlight the entire week in Green. can this be ... 14 May 2010 17:14

Select from a list of workbooks that are open
Hello, How do I display a list of workbooks that the user currently has open, and choose one from that list, so that I can activate that workbook and continue with macro processing. Many Thanks for your help. -- Programmer on Budget ... 2 Jun 2010 16:30

drop down fill in
here is what I am looking at. I have two seperate worksheets. on sheet A I have a drop down naming departments. on sheet b I have an area that basicallly from a2-a50 fills in with employee names. I need a macro to allow me to select the department and auto fill it with employee's based on the department. --... 17 May 2010 09:08