find and replace dialog in excel

S

shin

I am trying to make dialog box that will be popup from my addins in excel.
I want to have that dialog looks like the find and replace dialog. so that
user can select cells and type some character into a cell. Right now I
create
a kinda floating dialog using the following method. however i can only
select
cells but not able to right some characters into a cell.

mlHWnd = FindWindowA("XLMAIN", oHostApp.Caption)

'Enable the Window - makes the userform modeless
EnableWindow mlHWnd, 1

Any one has any idea how to create a similar to find and replace dialog in
the
excel?

Thanks in advance
Shin
 

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

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Modeless Userform in Word 97 0
How to use Find and Replace like I used to... 1
Excel wait for Find Replace dialog box in Word 4
Instantly use selected text for find and replace dialog? 4
Find/Replace MSWord wildcard characters from within Excel 6
How disable an Excel dialog box? 4
Limits of Substitute and Replace functions 4

Top