View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Data Form used in another worksheet

Maybe you could put a button from the Forms toolbar on sheet1 that uses the data
on sheet3 and displays the data|form dialog.

Option Explicit
Sub testme01()
Worksheets("Sheet3").ShowDataForm
End Sub

maybe sufficient.

Rick Tidd wrote:

I want to use a data form in say worksheet1, with the data residing in
worksheet3. Is this doable, or will I need to do the form in VBA?
Thanks
Rick Tidd


--

Dave Peterson