Sleeper: Using J-Walk's FaceID Tool

**MWE** · 08-28-2005, 01:18 PM

This is probably not the correct place for this, but ...

After my massive HD crash in June and the subsequent purchase of a new computer, it has taken a while to get things back to abnormal. I have been reloading tools I use in creating VBA applications and just reloaded John Walkenbach's button face id add-in. If you are like me, you can not remember even one of the faceID numbers no matter how many times they are used. If you have not stumbled across this nifty add-in, it is worth a click or two ...

http://www.j-walk.com/ss/excel/tips/tip67.htm

When I first starting using this tool, I was frustrated by my inability to keep the form on the screen while I "did other things". I made one change to the xla code to improve its use (at least for me). In the proc that actually displays the form, add "vbModeless" to the UserForm1.Show statement:

Sub ShowFaceIDs()
     UserForm1.Show vbModeless
 End Sub

**MOS MASTER** · 08-28-2005, 04:55 PM

Hi Mark,

Yes that add-in of John is very nice.

I always use the one from KeepitCool: "FaceIT" It has a lot more options and is able to output the masks of the FaceId's as well.

Have a look at it.

You can down it here:http://members.chello.nl/keepitcool/download.html

Or direct download:http://members.chello.nl/keepitcool/files/FaceIT.zip

**MWE** · 08-28-2005, 05:24 PM

Originally Posted by MOS MASTER

Hi Mark,

Yes that add-in of John is very nice.

I always use the one from KeepitCool: "FaceIT" It has a lot more options and is able to output the masks of the FaceId's as well.

Have a look at it.

You can down it here:http://members.chello.nl/keepitcool/download.html

Or direct download:http://members.chello.nl/keepitcool/files/FaceIT.zip

Thanks. I will download it and play a bit.

**JonPeltier** · 08-28-2005, 06:16 PM

FaceID addins like this are very common. I have my own, the third item on this page:

http://peltiertech.com/Excel/menus.html

Mine lets me store icon images and FaceID numbers in a worksheet for future reference, and it works as a couple of commandbars, so you don't have a modal form standing in the way of progress. It seems pretty slow to draw a set of icons, though.

PowerPoint MVP Shyam Pillai has versions for Excel, PowerPoint, and Word, and has even made a COM add-in version:

http://skp.mvps.org/faceid.htm

**MWE** · 08-28-2005, 07:41 PM

Originally Posted by JonPeltier

FaceID addins like this are very common. I have my own, the third item on this page:

http://peltiertech.com/Excel/menus.html

Mine lets me store icon images and FaceID numbers in a worksheet for future reference, and it works as a couple of commandbars, so you don't have a modal form standing in the way of progress. It seems pretty slow to draw a set of icons, though.

PowerPoint MVP Shyam Pillai has versions for Excel, PowerPoint, and Word, and has even made a COM add-in version:

http://skp.mvps.org/faceid.htm

Thanks for the additional leads.

**Scottie P** · 08-28-2005, 08:36 PM

Originally Posted by MOS MASTER

Hi Mark,

Yes that add-in of John is very nice.

I always use the one from KeepitCool: "FaceIT" It has a lot more options and is able to output the masks of the FaceId's as well.

Have a look at it.

You can down it here:http://members.chello.nl/keepitcool/download.html

Or direct download:http://members.chello.nl/keepitcool/files/FaceIT.zip

... can't get the FaceIT xla to load. I am getting an error.
Do you happen to know what refs/controls need to be set/installed for this item Joost?

I have just moved to a different (much better) PC and I likely have forgotten to install some things, etc. I did remember my MS Runtimes for a change!!

Scott

**MOS MASTER** · 08-29-2005, 01:28 PM

Hi Scott,

I think this one requires: Microsoft Windows Common Controls 6.0

So that would be: C:\Windows\System32\comctl32.ocx

If I'm not mistaken you should receive that from Office update if you did a full install of Office.

**MOS MASTER** · 08-29-2005, 01:32 PM

Originally Posted by JonPeltier

FaceID addins like this are very common. I have my own, the third item on this page:

Hi Jon,

Common indeed but I can't live without them making a nice toolbar. Like many people I tent to forget ID's as well.

Tried your addin out works very nice as well.

**MOS MASTER** · 08-29-2005, 02:19 PM

Hi Scott,

.

Just to make it easy on yah I attached a copy of my comctl32.ocx (Are you on XP as well?)

Put it in System32 folder (or the folder specified in your OS)

Go to Start | Run and put in:

Windows 95, 98, or Me:
regsvr32 \windows\system\COMCTL32.OCX

Windows NT or 2000:
regsvr32 \WINNT\system32\COMCTL32.OCX

Windows XP:
regsvr32 \windows\system32\COMCTL32.OCX

Now it should say something like DllRegisterServer ... succeeded or something like that. (After you press Enter of course)

Later

**Scottie P** · 08-29-2005, 03:03 PM

Believe it or not I have just -as of this weekend- moved to a new machine and installed Win XP Pro and SP2, but the ocx is not there...

Thanks for thinking of the zip file - I am going to set it up now!

Scott

**MOS MASTER** · 08-29-2005, 03:06 PM

Hi Scott,

Well that's strange... I knew the first version of Microsoft Windows Common Controls 6.0 was setup by VB 5.0 (So that's why I had it)

But I would have sworn COMCTL32.OCX (Sp2) was part of Windows XP Pro installation. (If there's time I'll track down it's origin)

O well it's a must have anyway cause it has some very nifty controls.

Glad I could help and keep me posted.

**MOS MASTER** · 08-29-2005, 03:08 PM

BTW what is your Office version?

I'm having thoughts now it should be part of Office 2003 as well? (But my brain is spinning at the moment...I'm not sure)

**Scottie P** · 08-29-2005, 03:15 PM

I am using Windows XP Pro with:
Office '97
Office 2K
Office 2K2 (XP) SP2

**MOS MASTER** · 08-29-2005, 03:19 PM

Ah Ok that explains it sorta..then please tell me you've installed them on Multiboot!

Or are they all installed on the same drive?

**Ken Puls** · 08-29-2005, 03:23 PM

Originally Posted by MOS MASTER

I'm having thoughts now it should be part of Office 2003 as well?

I have a copy in my Office11 folder (although it's in my System32 directory as well). So I think you'd be right on the Office 2003, Moose.

**MOS MASTER** · 08-29-2005, 03:26 PM

Originally Posted by kpuls

I have a copy in my Office11 folder (although it's in my System32 directory as well). So I think you'd be right on the Office 2003, Moose.

Yes that must be it cause I use dtpicker control a lot and I have never registered that ocx on a Office 2003 machine before but almost always on lower versions...

O well that settles it for me!

...(Getting tired too...Moose needs his sleep)

**MOS MASTER** · 08-29-2005, 03:32 PM

Ahums..Scottie??

Did you do the regsvr thingie yet?

(Help desk needs to close for tonight)

**Scottie P** · 08-29-2005, 03:51 PM

Yes - just (we are about to get stampeded by some serious weather so I was saving and closing up some things just in case

)

It is cool - the FaceIT addin is there now. I haven't had a chance to fool around with it yet, but I will later for sure.

I did some further investigating but to no avail - I thank you for the zip file!!

Scott

**MOS MASTER** · 08-29-2005, 03:56 PM

Hi Scott,

Good call!! I've heard it's pretty spooky with the weather on your side of the Ocean? (At leas New Orleans and such places)

So watch out!

Glad I could help yah out. Now I can finaly go to bed!

**Scottie P** · 08-29-2005, 04:00 PM

never need to wait up for me Joost...LOL!! Have a good sleep!
Oh...yes - all office installations are in their own burrows! No Office integration in that respect

S

Thread: Sleeper: Using J-Walk's FaceID Tool

Thread Tools

Display

Sleeper: Using J-Walk's FaceID Tool

Posting Permissions