LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default excel form activation in macro?

I have learned how to activate a form to fill in data that starts in A1. I
would like to be able to place my data table at another location (ie c25:h50)
and activate the form to fill it.

The syntax below opens a form that is located at A1... I tried making the
range of my data table be at c25:h50 using a... " range ("c25:h50").select"
.... statement and the form always defaults to what is at A1?

Private Sub CommandButton1_Click()
Range("A1").Select
ShowDataForm
End Sub

Also does the form that im using have to be on the same page as the data
table that im filling?


--
dr chuck

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
form activation? dr chuck Excel Programming 0 August 6th 06 10:32 PM
"combination drop-down edit " form activation in Excel Trev Excel Discussion (Misc queries) 1 March 4th 05 03:26 AM
Excel macro activation. Christine Flott[_2_] Excel Programming 1 July 30th 03 02:35 PM
Excel macro activation. Pete McCosh[_3_] Excel Programming 0 July 29th 03 04:59 PM
Excel macro activation. Dick Kusleika Excel Programming 0 July 29th 03 04:47 PM


All times are GMT +1. The time now is 06:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"