ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   edit box (https://www.excelbanter.com/excel-programming/302454-re-edit-box.html)

Harald Staff

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,





All times are GMT +1. The time now is 02:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com