Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |