Userform ques

[RamziSaab]

I have two question:

I have a userform that i want to keep open and use excel at the same time? How can this be done? i.e. so that i am able to edit cells?

Can a userform be put in as a custome toolbar? if so how?

Thanks?

 

[PHV]

Depending the version of Excel, you may try this:
UserForm1.Show vbModeless

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[RamziSaab]

yeah i tried it but i guess it does not work on Excel 97?
any other idea?

 

[RamziSaab]

i found a site to do it for excel 97

http://www.bmsltd.co.uk/Excel/Default.htm

but its under recontruction...anyone know the code?

 

[RamziSaab]

ok sorted it out...

the site is now

http://www.bmsltd.ie/Excel/Default.htm

the co.uk site got hijacked, and so was closed down this site is a mirror. (btw references in tek-tips posts are to co.uk so i thouht it would be useful to point it out)