Link Userform Ke Sheet. The data is housed in sheets already using manual methods for obtaining analytics. You may not be able to insert a hyperlink like you would on an excel spreadsheet but you can create a link by inserting a label and applying the onclick event.
Hi a warning beforehand i am using office 2003 but i can upgrade to 2010 if that makes things easier to solve. I am trying to link an excel spreadsheet with a word userform listbox. A hyperlink control is not provided in the toolbox when working with userforms but this clever trick will allow.
Data will get transferred.
Hi a warning beforehand i am using office 2003 but i can upgrade to 2010 if that makes things easier to solve. You may not be able to insert a hyperlink like you would on an excel spreadsheet but you can create a link by inserting a label and applying the onclick event. You ve asked a lot of questions here about your whole. Press alt f11 to launch the vbe.