Thread: Text box help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 292
Default Text box help

Hi

Textbox1.Text = Sheets(1).Cells(1, 2).Value
OR
Textbox1.Text = Sheets(1).Cells(1, 2).Text
(Text may have different formatting and different amount of decimals than
Value)

HTH. Best wishes Harald

"markorm " skrev i melding
...
Good morning...


Does anybody know how can I put the value of a cell I select into a
textbox on a form dynamically, i.e. while the form is open?

This pretty much relates to this: http://www.excelforum.com/t226561-s


---
Message posted from http://www.ExcelForum.com/