Thread: edit box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default edit box

Hi

If it's an Editbox on a Dialogsheet, you need a macro to move the content,
like

Sub MoveContent()
Sheets(1).Cells(3, 1).Value = DialogSheets(1).EditBoxes(1).Text
End Sub

assigned to an OK button or something.

HTH. Best wishes Harald

"IamHaxer" skrev i melding
...
On a custom Dialog can I have a user type in data (perhaps in an edit box)

and have the contents linked to a cell on a different sheet. I hope someone
knows, I know this will be the third dumb question that I have asked!
Thanks,