Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Automation advice
I have kept my explanation as simple as possible.
I tried using the macro recorder to record the code I want but didn't understand the steps I should follow when using the recorder to achieve the data input Month Number / Date to get the list I want as described below........ Problem I want to create a list of months as shown below Column A Column B 1 Oct 04 2 Nov 04 3 Dec 04 etc.......................... At the moment I create it manually Column A = ROW() copied down. Column B = Custom date format mmm-yy copied down. 10 and Oct 04 copied down would produce 1 to 10 .....Jan 04 to Oct 04 Question I have place a command button on the work sheet and named it "NewForm" I want to create code to attach to the command button which when run will display a form with two input boxes in sucession 1. Number of Months and 2. Date The result being a list of numbered months. Any sample code / advice would be much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
any advice pls.. | Excel Discussion (Misc queries) | |||
Supressing the ctrl-c and other keys during word automation in automation | Excel Programming | |||
need advice | Excel Programming | |||
Almost got it !! but need advice | Excel Worksheet Functions | |||
RTD Advice | Excel Programming |