Macro using Data Form

A

Al

Hi I want to create a macro to allow users to enter data using data form.

Having set up my worksheet I have selected column headings. I then sedlect
Data > Form, at which point I get an annoying message up saying that Excel
doesn't kn ow which rows to use as headings. I can click Ok to go pastg it,
but is there anyway to inhibit the message in the first place?
if I select column headings, plus firfst row of data, I dont have a problem,
but then the data form comes up with the first row of data in form - which I
dont want.

Thanks
A
 
D

Dave Peterson

Didn't the followup to the other thread help?
Hi I want to create a macro to allow users to enter data using data form.

Having set up my worksheet I have selected column headings. I then sedlect
Data > Form, at which point I get an annoying message up saying that Excel
doesn't kn ow which rows to use as headings. I can click Ok to go pastg it,
but is there anyway to inhibit the message in the first place?
if I select column headings, plus firfst row of data, I dont have a problem,
but then the data form comes up with the first row of data in form - which I
dont want.

Thanks
A
Click to expand...
 
D

Dave Peterson

application.displayalerts = false
ActiveSheet.ShowDataForm
application.displayalerts = true

Remember that you can use google to find your old threads.
 
Top