Excel userform always visible

[DrSmyth]

Hi, not sure if you can do this in excel, but i need to make a userform always visible and in the same place (in relation to the application window), even when the user is selecting cells and scrolling around in the underlying spreadsheet....

Thought it would just be a matter of changing the setfocus settings, but userforms in excel don't seem to have them...

would appreciate any help/suggestions you may have..

Dr

 

[TonyJollans]

Hi DrSmyth,

Providing you have at least Excel 2000, you can have modeless Userforms. Show them with

[blue][i]UserFormName[/i].Show vbModeless[/blue]

.

Moving it around is another matter altogether - the User can move it and might be a bit peeved if it suddenly jumped somewhere else.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[DrSmyth]

sorry Tony, should have mentioned, we're using office 97 (and windows NT, which may give you an idea of how "old school" my company is.....)

guessing that modeless function is not available on 97??? or is it??

 

[combo]

Look at Stephen Bullens excel page

http://www.bmsltd.ie/Excel/,

ModelessForm.zip file is an API solution for excel 97

combo

 

[DrSmyth]

Thanks for the pointer.... The site you've linked to is brilliant... The modeless forms are definitely usuable...

Thanks again...