Hi guys,
The following shows code (which I copied off the internets) to place an icon in my userform's caption
It works fine! However, I have quite a few userforms and didn't want to chunk up their code with repeated instances of the above. Is there an easier way to do this?
Please Login or Register to view this content.
Thanks!
In a normal module:
then in the userforms:Please Login or Register to view this content.
Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
Thanks romper! Worked perfectly.
I do have a question though - why must multiple modules be created? For example, if I copy this into a module which I have my OpenFile code in, it comes up with the whole "Only comments may appear after end sub, end function..." etc.
You can use an existing module as long as you put this part above any existing routines:
Please Login or Register to view this content.
Ah! That makes sense.
Apparently I have to spread some reputation around before giving some to you again. Hmph. Clearly you deserve the lion's share of it XD
Last edited by MarmaladeLover; 09-11-2014 at 10:44 AM.
Don't worry - a simple thanks is sufficient!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks