Find function

[tvp0905]

Hello. I am new to VBA programming, and I'm stuck on a work assignment.

Specifically, I have created a user form with a list box. My code is selecting the data I want, and verifying my choice from the list box. From there, I want the macro to find my data in the spreadsheet, but instead my code is only moving my cell pointer one space to the right each time.

I have the following code set up to choose from my list box

Please Login or Register  to view this content.

CHOOSE_EMPLOYEE.Value is the item that the user selected from my list box (only one choice allowed). This code seems to be working correctly.

Here's the code to find the selected item in my worksheet:

Please Login or Register  to view this content.

What I want to happen is to take the value selected from the list box and find it in my worksheet. What is happening, though, is that rather than finding the data Excel is simply moving my cell pointer one cell to the right. Obviously, I'm overlooking something.

As I said, I'm new to this, so any and all help is greatly appreciated. Thanks so much!!

[mgs73]

Can you upload the workbook?

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

[tvp0905]

Sure. File attached.

Thanks again for your help. I appreciate it.

[tvp0905]

Done. Thanks again for your help.

**SORRY FOR THE DUPLICATION. I'M NEW TO THE SITE AND DIDN'T NOTICE THE ORIGINAL REPLY HAD POSTED**

[mgs73]

I've modified the code below - basically, when you unload the user form, CHOOSE_EMPLOYEE.Value no longer means anything, so you need to assign it to a variable before you close the user form.

Please Login or Register  to view this content.

[tvp0905]

That did the trick!

Thanks so much for your help. I very much appreciate it.