MrExcel Publishing
Your One Stop for Excel Tips & Solutions

macro for form

Posted by warren on October 27, 2000 3:48 AM

I have a macro that bringss up a form for the user to enter data into a list. the problem is that it will not pull the form up when it is run, when i try it manually the form comes up what am i doing wrong.
Here is the macro


any input would be appreciated

Posted by Ivan Moala on October 27, 2000 4:10 AM

I think you have to define a label for your dataform then select the range for your dataform.
PLUS put in application.displayalerts=false to
bypass the popup alert IF your data range is selected eg.

Application.DisplayAlerts = False
Application.DisplayAlerts = True



Posted by warren on October 27, 2000 4:24 PM

thanks Ivan