placing dialog box for showform

[rkp]

I am teaching myself basic VBA thru the version found in EXCEL,Is
there a way to use data in other than the first two lines on a
spreadsheet. Or, is there a VBA routine that mimics the showform?

 

[Ronald Palmgren]

Steve,
tried to use the recorder but the code shows "activesheet.showform" and
"activesheet" cannot be modified with say "range(d35).select"

any other thoughts?thanks

rkp


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[steve]

Ronald,

You may have to first select the sheet and than select the cell

Sheets("Sheet1").Select
Range("D35").Select
Activesheet.Showform

But the best place to start is in the header row.
Also - you need a contiguous range of cells for this to run smoothly.

 

[steve]

Ronald,

I don't know about "showdataform".
I am using Excel97 and have 2 choices
Showform
or build my own form

Your original post said something about "a way to use data in other than the
first two lines on a spreadsheet"

Maybe you should repost with a more detailed explanation of what you are
trying to do. Anything is possible once the goal is clearly outlined.
Cut, copy, paste, change value, lookup values, .... anything.
Let you imagination rule. Just spell it out for us and we'll help.