Reducing the size of the Search Dialogue Box

A

aca

In my program, I often need to use Search fonction, the general one in
the Edit menu of Excel; so, I have that dialogue box permanently open,
in a corner of the screen. But that box, as it is, takes too much space
and hides a big patch in the screen (even when reducing it as much as it
is possible).
Is there a way of modifying its size, to make it even smaller?
Thanks for any help
ACA
 
R

RB Smissaert

You could try with the Windows API like SetWindowPos.
I don't think though that in this case you can reduce the width with that.
If it is really important you may have to write a replacement in a Userform.

RBS
 
A

aca

Thanks, RBS.
The API like SetWindowPos is far too advanced for me; the Userforms
I've tried do work, but they aren't quite as effective as Excel's own
Search function.
Thank you again.
ACA
 
A

aca

Thank you, RBS
Your firs suggestion is far too advanced for me.
My userform does work does work, though it's not quite as effective as
Excel's owun Search function
Thanks again.
ACA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top