how to bring up a data form with VBA

[Paul James]

I've got a table of data that I would like to display in Excel's built-in
data form that you can call up manually by highlighting a range of data and
selecting the Form command from the Data menu. However, I would like to
write a VBA procedure that would enable the user to do this by simply
clicking on the command button.

The region I would like to display in this form could be described as

Range("DataTable").CurrentRegion

Can anyone tell me what code I can use to bring up Excel's built-in data
form to display the data in that range?

Thanks in advance.

Paul

 

[Paul James]

Thanks for your help again, Tom.

 

[Tom Ogilvy]

My mistake. Glad you fixed it.