Vlookup and POPUP

[[email protected]]

Hello,

I'm looking to get a POPUP on tab "Estimate" (sample shown on qryStockcodePricing tab). When a part# is typed into cell B22 on the Estiamte tab it will then Vlookup on qryStockCodePricing tab and a POPUP screen will indicate all relative price codes as show in the sample.

I have attached a sample sheet. Any help would be most appreciated. Thank you for your efforts.

[[email protected]]

Can anyone help me on this one? Thank you.

[Winon]

Hello [email protected],

Try the attached WorkBook. I have added a DropDownBox for you where you can select the Product Code you wish to enter in Cell B22.

Also see the "Please consider" note at the bottom of this post.

[[email protected]]

Hi Winon. Thank you for your response! It's almost there. Two things:

1. If I manually type in a part that isn't on the "qryStockCodePricing" sheet Pop stays blank.
2. Anyway to close the box after the pricing pops up?

Thank you again.

[Winon]

Hello [email protected],

1. If I manually type in a part that isn't on the "qryStockCodePricing" sheet Pop stays blank.

That is exactly what should happen. How do you expect the "Sheet Pop" to show any data of something that does not exist?

2. Anyway to close the box after the pricing pops up?

The "Pop-up Box" will disappear automatically as soon as you exit Cell B22, and you enter or delete data in any other area of the Active Sheet.

You cannot close the "Pop-up Box" manually, unless you would want to add a Button to the Sheet for this purpose.

Hope that helps.