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

Range("A14").Select
ActiveSheet.ShowDataForm

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
Range("B2:B12").Select
ActiveSheet.ShowDataForm
Application.DisplayAlerts = True


HTH


Ivan

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

thanks Ivan