To create Faceplate, please.

[iqballud]

Hi,

I've been stuck to find out the code to create faceplate.
The faceplate, this like the new popup form 'Find and Replace' in excel when we click on the button.
I'm really appreciate with your golden hands to solve it, please.

Best Regards,
Iqballhud

[AliGW]

By 'faceplate', do you mean 'user forum'?

[fakhteh]

hi
if it is not complicated you can use this:

Right-click the QAT(Quick Access Toolbar)., and click Customize Quick Access Toolbar
From the drop down list, select All Commands
Scroll down and click on Form…, then click Add, to put it on the QAT
Click OK, to close the window
Select a cell in the list, then click the Form button on the QAT

[iqballud]

No, Ali.. if we press "Find & Select" button and click on 'Find..' on the Excel, then the pop up window will appear as 'Find and Replace". This new window, I call as faceplate and this is the one what I need to IF I would like to press any CommandButton/Text in UserForm that will be created.

[AliGW]

So does post #3 above answer your query, then?

[iqballud]

Hi,
Actually I will use the faceplate on the UserForm if any CommandButton/Text will be clicked, then the Faceplate will be appeared.

[fakhteh]

hi i guess you want something like this in link below:
https://support.office.com/en-us/art...d-9c72c843a283
is it?

[iqballud]

Hi,
As I was mentioned above, if the faceplate will be appeared if the commandButton clicked on the UserForm.
This faceplate something like the "Find & Replace" form on the excel if we click on Find & Select then click on Find.

[AliGW]

The word "faceplate" is not being fully understood here. Can you please show an image of what you want, just to clear this up? Otherwise we shall be going round in circles.

[iqballud]

Hi Dear,

I'm really sorry because very late to reply regarding with my issue.
I was lost hope and I think this issue will not solved, finally I wish It can be solved.
Please find the "faceplate" example in the attachment as I was mentioned above.
The faceplate, what I meant like in "Find and Replace" in excel.
The faceplate will always displaying even though we will open another new excel workbook.

Example, I will open the faceplate from UserForm1 by CommandButton1. Then I will open another UserForm2 from CommandButton2.
I need this faceplate will always open or displaying even though the Userform2 will opening now.
I was tried to use "Frame" (i.e. under UserForm1) but this Frame only open/displaying in UserForm1 only.
And if I will open another UserForm (i.e. UserForm2), the Frame will be gone.
I need the Frame still open/displaying even though another UserForm will be opened.

I wish, what I was explained you can understand what the issue.
And thank you so much for your golden hands, Sir.


Kind Regards,
Iqballhud

[iqballud]

Hi,

Looking forward from your reply..

[sintek]

So....Do you want to create a UserForm that has the function of a find replace "FACEPLATE" as you call it...
Tha t will allow user to search your worksheet for something and replace that value with something else...

[iqballud]

I don't want to create UserForm as function of a find & replace.
I need to create faceplate under UserForm and the faceplate will be appearing always even though another UserForm will be called.

This is the steps to explain about what I need:
1. I will create UserForm1 and UserForm2.
2. I will create a faceplate1 under UserForm1. To call this faceplate, the CommandButton1 will be created and under UserForm1.
Then the faceplate1 will be appeared.
3. If I will open another UserForm2, the faceplate1 will be disappeared from UserForm2 because the faceplate was created under the UserForm1.

I need the faceplate which will be always appearing, even though another UserForm will be opened.

I was tried to use the "frame", but it doesn't work.
The frame will be appearing only under UserForm which the frame was created.
And if another UserForm will be opened then the frame will be disappeared, of course.

I was attached the file for your refferrence, Sir.
And again thank you so much for your helps and guidance.

Kind Regards,
Iqballhud

[iqballud]

Hi,

Anything that I can do to solve this issue..

Thanks,
Iqballhud

[iqballud]

Regards,
Iqballhud