I am currently working on a project where I have a collection of textboxes which are storing various entries of text. Next to those textboxes I am trying to add some buttons, that when clicked, call a userform that is used to add a new entry to the respective text box (the boxes being otherwise read only). For this to work each button needs to return its respective cell address to the user form. I have everything working nicely for the textboxes (through the use of its 'LinkedCell' parameter) but the command buttons have no such link. Even this would not be a problem except that my spreadsheet needs to allow for the insertion of new rows and columns. This means that a static routine for each button will not work because I can't find a way to make it update with a shifting spreadsheet.
So anyway, here is my question. Is there a way to dynamically link a command button to a cell or activeX textbox. Could I just trick my textbox into acting as a button (as long as scrolling still works)? Can I create a custom acitiveX controll? Any information on this matter would be a great help. Thanks for your time.
So anyway, here is my question. Is there a way to dynamically link a command button to a cell or activeX textbox. Could I just trick my textbox into acting as a button (as long as scrolling still works)? Can I create a custom acitiveX controll? Any information on this matter would be a great help. Thanks for your time.