Thread
:
Excel macro which prompts for input and moves to a cell - repeated
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
KenZimbo
external usenet poster
Posts: 1
Excel macro which prompts for input and moves to a cell - repeated
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 With Quote
KenZimbo
View Public Profile
Find all posts by KenZimbo