placing dialog box for showform

  • Thread starter Thread starter rkp
  • Start date Start date
R

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?
 
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
 
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.
 
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.
 
the showdataform function is obtained from using the data/form on the
main excel menu bar. If you type some numbers in the first few columns
and some titles in column A jan feb mar
i.e. Sales 100 200 300
op exp 20 30 40
then go to the menu and hit data then form you will see a dialog box. I
repeated the process with the macro recorder on then saved the macro.
Went into the tools, macro, and hit edit and when the macro coding comes
up you will see the line saying "activesheet.showdataform"
 
Back
Top