GrantLund
08-18-2006, 12:55 AM
Hi all :hi:
I've been doing some work in word and now am trying to convert to excel as I am hitting some limitations in terms of presentation. With respect to this I have two challenges:
(1) How to copy userforms from Word into Excel. I can copy textboxes and command buttons, ie. everything on a userform in word into another userform in excel but I want to copy the complete userform with its properties. Is this possible?:think:
(2) I want to have a command button on the main worksheet that if you click takes you to any other sheet (which one has specified). What is the code for this? :banghead: I know one can use hyperlinks in the cells to jump to worksheets but would like to use a command button instead (presentation is better).
Any suggestions would be most welcome.
Grant
I've been doing some work in word and now am trying to convert to excel as I am hitting some limitations in terms of presentation. With respect to this I have two challenges:
(1) How to copy userforms from Word into Excel. I can copy textboxes and command buttons, ie. everything on a userform in word into another userform in excel but I want to copy the complete userform with its properties. Is this possible?:think:
(2) I want to have a command button on the main worksheet that if you click takes you to any other sheet (which one has specified). What is the code for this? :banghead: I know one can use hyperlinks in the cells to jump to worksheets but would like to use a command button instead (presentation is better).
Any suggestions would be most welcome.
Grant