placing dialog box for showform
 

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?

placing dialog box for showform
 

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!

placing dialog box for showform
 

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.

--
sb
"Ronald Palmgren" wrote in message
...

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!