Start up window on spred sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreed sheet and would like a window that pops up when I open it so I can fill in basic information on the spread sheet. I have seen this done but not sure how to do it. Tahnsk KC
 
Hi
you can use the workbook_open event for this. e.g. put the following
code in your workbook module (not in a standard module):
sub workbook_open()
dim res
res = inputbox("Enter your main value")
me.worksheets("sheet1").range("A1").value=res
end sub
 
And maybe Data|Form is what you're looking for.
I have a spreed sheet and would like a window that pops up when I open it so I can fill in basic information on the spread sheet. I have seen this done but not sure how to do it. Tahnsk KC
Click to expand...
 
Back
Top