Macro using Data Form

[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

 

[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

 

[Al]

Dave
Not sure why, but I seem to have lost the other thread on laptop

Al

 

[Dave Peterson]

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

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