View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul James[_3_] Paul James[_3_] is offline
external usenet poster
 
Posts: 58
Default how to bring up a data form with VBA

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