Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
G'day there Tom,
The control will need to be installed on the computer where it is used. It is not embedded in the file. Dammit!! I thought that may be the case, but wasn't sure whether I could statically link it some how. Obviously not. I'm sure Microsoft did it that way on purpose, just 'cause they hate me. A userform does not support hyperlinks. John Walkenbach has a workaround: http://www.j-walk.com/ss/excel/tips/tip71.htm Hmmm... I don't understand why it wouldn't, but if that's the case I'm off to see what Mr Walkenbach has to say. He also has articles on dynamically adding controls and so forth including class module to handle the events for multiple controls (commandbuttons in the article, but suitable for all MS Forms 2.0 controls - although only native events): http://www.j-walk.com/ss/excel/tips/userformtips.htm Now THAT will come in handy!!! Thanks very much for your reply, Tom. I appreciate it greatly. Dunno what date it is where you are, but over here it's 25 Dec. So Merry Xmas! Take care and perhaps we'll speak/type again. Thanks once more. -- See ya, Ken McLennan Qld, Australia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2 Label Options - Forms Object vs Control Box Object | Excel Discussion (Misc queries) | |||
Object Creation | Excel Programming | |||
Option button object proeprties or object not found in vba | Excel Programming | |||
Confusion about how the Window object fits into the Excel object model | Excel Programming | |||
Range object to Array object conversion | Excel Programming |