Can anyone offer a bit of information on how to create a form that places
data valuses in a certain cell. I have download cortexure samples programs
and need help figuring them out.
Can anyone offer a bit of information on how to create a form that places
data valuses in a certain cell. I have download cortexure samples programs
and need help figuring them out.
hi,
Create a form with a text box(with id lable) and and command buton. in the
text box property sheet, gve the text box the name txtInput1(or a name you
will remember easily)
code for the command button.
sub CmdBut_click()
dim rng as range
set rng = Range("A1")
rng = me.txtInput1
me.txtInput1.setfocus
end sub
with this code whatever you input into the text box will appear in cell A1.
you can add more text boxes and change the destination cell.
good luck
FSt1
"Victor" wrote:
> Can anyone offer a bit of information on how to create a form that places
> data valuses in a certain cell. I have download cortexure samples programs
> and need help figuring them out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks