Excel start up

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

How do you create a macro that will perform certain
function in an excel spreadsheet that will go to cell b2
wait for me to type data go to cell b4 wait till I type
data then proceed to cell e4 wait till data is input, then
e5, and over and over for cells that i would choose. I am
familair with macros, but don't know how to get it to stay
until I type data in those cells. Also want this to
perform for every worksheet that I open with this xls file.

Thanks
 
Jeff,
How about creating a userform to input the data?
Use text boxes on the form for data input.
Put a command button on the form and give it the caption Save.
code the click event as:
Sheets("sheet1").Range("B2").value = textbox1.Value
etc, etc.
If your data goes into the same cells on every sheet then you could put a
combo or list box at the top to select which sheet you want to fill in.
The Save click event could then be coded as:
Sheets(Combobox1.value).Range("B2").value = textbox1.Value
etc, etc


HTH
Henry
 
Back
Top