Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to send the current value of a cell to a
textbox on a form. I ultimately would like the user to then edit the data and upon pressing an "ok" button to send the updated information back to the cell. Thus far I have: txtA = ActiveSheet.Cells(Count, 1).Value txtB = ActiveSheet.Cells(Count, 1).Offset(0, 1).Value txtC = ActiveSheet.Cells(Count, 15).Value frmForm.Show The text does not appear in the textboxes on the form when it loads, but I know it is assigning the value. How do I make it appear on the form? How do I then get it back to my spreadsheet? Thanks Pat |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Set Textbox on a Form to Deafault | New Users to Excel | |||
Text Size in Label or Textbox in Form | Excel Discussion (Misc queries) | |||
File in 2007 form - need to get back to 2003 form... | Excel Discussion (Misc queries) | |||
end down option in a textbox of a form | Excel Discussion (Misc queries) | |||
Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) |