| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transferring Data from Code to a Textbox in the Form
Thank you for your help! I got it to work...
Tom "JLGWhiz" wrote: P.S. SMPL would have to be a public variable to be used between modules. "TomP" wrote: I have a value collected from a code and have cell assignment. Dim SMPL as String Range "A1" = String I started to create a form and textbox along with the common OK and cancel button, but is there a simple way to pass a string value to a form? When I ran the code and initialized the form the text box would show Me.Change1.Value=(SMPL). *** From a Form *** Private Sub Change1Text_Change() Me.Change1.Value = (SMPL) End Sub My intention is to create a checkbox next to the texbox. If the checkbox = true then the string will be placed in the cell. If the checkbox = false, then the string will be null and not printed. The reason I am asking this because at times, the "user" will need to have the option to select all or portions of the data collected. Thank you, Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transferring from one form to another | Excel Discussion (Misc queries) | |||
| Transferring Control From VBA Form to Spreadsheet | Excel Programming | |||
| macro that takes data entered in a user form textbox to go to a ra | Excel Programming | |||
| Transferring information from one user form to another | Excel Programming | |||
| Transferring information from textbox to new spreadsheet/document | Excel Programming | |||
Hybrid Mode
