View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Activate Form using a macro

http://support.microsoft.com/default...b;en-us;213835

--

Vasant


"Voldemore" wrote in message
...
I'm trying to do something relatively simple. I want to run a small macro
that will automatically click on a cell (range name of "begin") and then
active the Form (Data - form...). This is a work related worksheet, and

my
co-workers can not remember where to activate the form.

Now, I tried doing the recorded macro, but it always fails. I have seen

this
macro, but I can't seem to recreate it. What am I doing wrong??

"Sub Userform()
'
' Userform Macro
' Macro recorded 5/22/2005 by Voldemore
'

'
Range("A4").Select
ActiveSheet.ShowDataForm
End Sub"