I need to assign value of ActiveX TextBox to A1 cell. But I'm getting error when using this code:
What is wrong in the code?![]()
Please Login or Register to view this content.
I need to assign value of ActiveX TextBox to A1 cell. But I'm getting error when using this code:
What is wrong in the code?![]()
Please Login or Register to view this content.
Last edited by JosephP; 03-10-2013 at 05:22 PM. Reason: add code tags
it'sor![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
How about:
![]()
Please Login or Register to view this content.
Gary's Student
Possibly you can dispense with code altogether by using the LinkedCell property of the textbox.
Just set the property to reference the sheet/cell
In the property box for linked cell, simply type: Sheet1!A1
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks