Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel macro which prompts for input and moves to a cell - repeated
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel macro which prompts for input and moves to a cell - repeated
Many ways. Here is one idea. You could also unlock the cells to gotoput a
comment in eachprotect the sheet. Sub enterdatainselectedcells() q1 = InputBox("enterdata1") If q1 < "" Then Application.Goto Range("b2") q2 = InputBox("enterdata1") If q2 < "" Then Application.Goto Range("b12") 'etc End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "KenZimbo" wrote in message ... To: All pundits in Microsoft Excel From: Ken Spencer in Zimbabwe (Email: ) Subject: Kindly requests help on Microsoft Excel. Date: 8 September 2008 In Lotus 123, (which I have long since stopped using) I used a simple Macro to: 1. Go to a cell 2. Get a prompt to enter a value, e.g. €œEnter €˜Month of Year€ 3. Enter the value and press Enter to move to another cell. 4. Get another prompt to enter another value, e.g. €œEnter €˜Sales Volume for the Month€ 5. Enter the value and press Enter to move to another cell 6. Etc Etc. Can anybody out there please tell me how I can do this in Excel by recording keystrokes in a Macro? Please note I havent the first clue about Microsoft Visual Basic. Thanks in advance Kindest regards Ken Spencer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run macro with input msg based on cell input | Excel Discussion (Misc queries) | |||
Excel: When I arrow down, it moves the page, not to new cell. | Excel Discussion (Misc queries) | |||
How to disable macro prompts for OK in Excel? | Excel Discussion (Misc queries) | |||
Printing text in a repeated cell/row that is longer than repeated | Excel Discussion (Misc queries) | |||
How can I suppress prompts during macro run? | Excel Discussion (Misc queries) |