Form Issue

**Geordie** · 05-13-2010, 12:57 PM

Hi

i have generated a form which i now would like to insert a option in the form (not on the form) which is named About and when the user clicks on it it reveals the form details for example the writers name, issue number and date

hope someone can understand exactly what i want and have the solution

many thanks

**Leith Ross** · 05-13-2010, 01:01 PM

Hello Geordie,

Do you want to add an "About..." menu item to the form? Is this form a worksheet or a VBA UserForm?

**Geordie** · 05-13-2010, 01:23 PM

Hi Leith

its a VBA userform

and i would like it to embedded in the actual form, not from the control tool bpx if this makes sense?

**Leith Ross** · 05-13-2010, 01:41 PM

Hello Geordie,

I see now what you mean. You want to have this in the UserForm Properties Sheet. The properties are determined by the object's class. VBA can not modify the Properties page of another object. You would have to write a COM Add-In to change the Properties page.

**Geordie** · 05-13-2010, 01:51 PM

is that easy to do

something you couldhelp me with?

**Geordie** · 05-13-2010, 01:57 PM

just googled com add in

looks a bit complicated for me

with just insert a label with date and issue number

alot easier/quicker

thanks anyway

**dominicb** · 05-13-2010, 02:16 PM

Good evening Geordie

Have a look at this post : it has a link that you may find useful.

http://www.excelforum.com/excel-prog...and-menus.html

HTH

DominicB