Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating custom list with a comma in it | Excel Discussion (Misc queries) | |||
Open Userforms from a Dropdown list | Excel Discussion (Misc queries) | |||
Creating a formula using absolute referencing - I think!! | Excel Worksheet Functions | |||
Eliminate creating list that returns blank cells | Excel Worksheet Functions | |||
creating an x,y chart | Charts and Charting in Excel |