Edit VBA Userform code to run if only 1 entry that matches criteria

**ExcelFailure** · 07-23-2013, 06:39 AM

Hi there

I have the following code:

Please Login or Register  to view this content.

Can anyone help me to edit the code so that if there is only one entry that meets the criteria, it will be just put into the selected cell when I run the macro?

Thank you.

**:) Sixthsense :)** · 07-23-2013, 06:53 AM

I am unclear about your requirement

Can you please explain which part needs to be edited?

**Norie** · 07-23-2013, 07:20 AM

What criteria?

**ExcelFailure** · 07-23-2013, 08:08 AM

Sorry I'm fairly new to VBA - hence the username..

At the moment, what it does is searches in ("a2:a5567") and returns any of the entries that match the criteria. The criteria is what I've already typed into the cell. So I type something in and then run the macro and it is effectively a drop down but it comes up in a userform instead.

This make sense or no?

**Norie** · 07-23-2013, 08:16 AM

If there's only going to be at most one match, why a combobox? Wouldn't a simple textbox suffice?s

**ExcelFailure** · 07-23-2013, 08:19 AM

No there sometimes will be more than 1 match - normally in fact...

So I'm basically searching in the range for the text in cell and then returning the results in a userform..as far as i understand

**Norie** · 07-23-2013, 08:21 AM

The title says 'only if 1 match'.

Anyway, perhaps if we saw what you have it might help clarify things.

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

**ExcelFailure** · 07-23-2013, 08:27 AM

Yep Ok I'll do that in just a sec. Basically what it is is IF there is only 1 match I would like it to automatically chose that one for me.

**ExcelFailure** · 07-23-2013, 08:38 AM

Sample1.xlsm Here it is

**:) Sixthsense :)** · 07-23-2013, 11:53 PM

Just add this piece of code after the loop

Please Login or Register  to view this content.

**ExcelFailure** · 07-24-2013, 01:42 AM

Thanks..what do you mean by the loop?

**:) Sixthsense :)** · 07-24-2013, 02:22 AM

Check the below code for details to know where to add the suggested code...

Please Login or Register  to view this content.

**ExcelFailure** · 07-24-2013, 02:40 AM

Thanks that works - how do I unload the userform after it's chosen the word for me?

**:) Sixthsense :)** · 07-24-2013, 03:11 AM

Just close it by clicking the X mark.

**ExcelFailure** · 07-24-2013, 05:04 AM

Ok so I can't get it to do that for me?

**:) Sixthsense :)** · 07-24-2013, 05:20 AM

Add this unload me in the below area

Please Login or Register  to view this content.

And add this On Error Resume Next in the below area

Please Login or Register  to view this content.

**ExcelFailure** · 07-24-2013, 05:23 AM

Excellent, perfect. Thanks very much for your time. Have some rep

**:) Sixthsense :)** · 07-24-2013, 05:25 AM

Glad it helps you and thanks for the feedback and rep

Edit VBA Userform code to run if only 1 entry that matches criteria

LinkBack

Thread Tools

Rate This Thread

Display

Edit VBA Userform code to run if only 1 entry that matches criteria

Re: Edit VBA Userform code to run if only 1 entry that matches criteria

Re: Edit VBA Userform code to run if only 1 entry that matches criteria

Re: Edit VBA Userform code to run if only 1 entry that matches criteria

Re: Edit VBA Userform code to run if only 1 entry that matches criteria

Re: Edit VBA Userform code to run if only 1 entry that matches criteria

Re: Edit VBA Userform code to run if only 1 entry that matches criteria

Re: Edit VBA Userform code to run if only 1 entry that matches criteria

Re: Edit VBA Userform code to run if only 1 entry that matches criteria

Re: Edit VBA Userform code to run if only 1 entry that matches criteria

Re: Edit VBA Userform code to run if only 1 entry that matches criteria

Re: Edit VBA Userform code to run if only 1 entry that matches criteria

Re: Edit VBA Userform code to run if only 1 entry that matches criteria

Re: Edit VBA Userform code to run if only 1 entry that matches criteria

Re: Edit VBA Userform code to run if only 1 entry that matches criteria

Re: Edit VBA Userform code to run if only 1 entry that matches criteria

Re: Edit VBA Userform code to run if only 1 entry that matches criteria

Re: Edit VBA Userform code to run if only 1 entry that matches criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Userform multipage control exit events code execution not completed before next user entry

Populating VBA userform and Fetch previously entered data edit and make new entry

VBA Code to Search/Edit Data Populated by Userform

Return last entry in column that matches criteria

Edit code to add extra criteria

Bookmarks

Bookmarks

Posting Permissions