Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 5th, 2007, 01:40 PM
Registered User
 
Join Date: Mar 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Banquo_ws
Default First Post! adding an icon to a custom user form

Hi!

First Post!

I have modified a user form so that it looks like this:

http://files.myopera.com/bazewouelle...s/199338/2.JPG

Now I would like it to look like this:

http://files.myopera.com/bazewouelle...s/199338/1.JPG


How do I do that???

Thanks !

Antoine

http://orchus.spaces.live.com

"The lion will not touch the true prince"
 
Old March 6th, 2007, 04:35 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 173
Thanks: 0
Thanked 3 Times in 3 Posts
Default

There's a class modules that's been written (by Stphen Bullen) to extend the functionality of UserForms. You can use this to chose and amend your icon amongst other things. Have a look at this post for the class module code:

http://p2p.wrox.com/topic.asp?TOPIC_ID=19907

The slightly cryptic link in that post referes to this further post:

The two additional lines of code you will specifically need in the vernacular of the archived post are:

Code:
oFormChanger.IconPath = "C:\myiconpath.ico"
oFormChanger.ShowIcon = True
HTH,
Maccas

 
Old March 6th, 2007, 04:36 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 173
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Sorry couln't get that second link to print out ok. Tkae the text from the > character and you should be ok.

Maccas






Similar Threads
Thread Thread Starter Forum Replies Last Post
adding new worksheet using user form sime_tyres Excel VBA 1 February 21st, 2006 12:35 AM
User Form: How to get rid of icon "X" Axxess Excel VBA 2 September 26th, 2005 05:34 AM
Custom Icon bmains Visual Basic 2005 Basics 9 May 11th, 2005 07:28 AM
Custom Icon for ASP.NET Control bmains ASP.NET 2.0 Basics 0 September 22nd, 2004 05:09 PM
VBExclamamation Icon on my own form? Plowking Beginning VB 6 1 October 30th, 2003 10:08 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.