Thread: Macro Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Macro Help

it might help if we could see your template
-----Original Message-----
In Excel 2002, I have a template that calculates total

footage of a unit
of lumber. In that template, after user enters the

required data, I
have a macro that is attached to a button that prints the

page. What I
want to have this macro to do is to ask the question "Do

you wish to
enter another tally? (Y/N)" - if the answer is "Y"

or "y", clear the
entered data, go to the first cell that requires data

entry, then end.
If the answer is "N" or "n", close the worksheet.

I have done this in Lotus/123 using the GETLABEL and

BRANCH macro
commands, but I can't find/can't see or am just not

understanding how
to do this in Excel. Any help and guidance would be

appreciated!!!


---
Message posted from http://www.ExcelForum.com/

.