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?

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!

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!