x5225642
asked on
Excel VB: Unloading TextBox in a UserForm to cell.
Hi,
I've set up a UserForm in Excel which contains a TextBox. The data in this TextBox I need copying into a cell. The cell reference where I need this data to end up is written in A1. I'm struggling to put together a code which will use the cell reference displayed in A1 to copy the data to.
Has anyone got any suggestions? I'm in a bit of a time pinch.
Thanks :)
I've set up a UserForm in Excel which contains a TextBox. The data in this TextBox I need copying into a cell. The cell reference where I need this data to end up is written in A1. I'm struggling to put together a code which will use the cell reference displayed in A1 to copy the data to.
Has anyone got any suggestions? I'm in a bit of a time pinch.
Thanks :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Fast response and worked first time :)
Thank you
Thank you
You're welcome. Glad I could help.
ASKER