showing message box if the result of texbox doesn't match with the range then clear texbox

**hamidrezaxy** · 06-20-2013, 07:13 AM

Hi;

1- As my attached file, i want to show messaage box in case of the result of texbox1 (ID+Candidate) doesn't match in the range ( C column ).
2- I wonder if ther is a way to create a dynamic combobox2 depends on combobox1.

So many thanks in advence.

**tehneXus** · 06-20-2013, 11:31 AM

Hi,

I don't get the point on checking the text in the text box every time you enter a new character, it will result in a lot of message boxes. Instead I've implemented a comparison between the "CandidateID" in the sheet with the combination of the combobox selections. Comobox1 displays unique values, combox2 is filled based on selection of combobox1: Userform.xlsm

**hamidrezaxy** · 06-20-2013, 01:04 PM

It's perfect.
I hope, I could do reverse engineering for my main file.

Thanks alot

showing message box if the result of texbox doesn't match with the range then clear texbox

LinkBack

Thread Tools

Rate This Thread

Display

showing message box if the result of texbox doesn't match with the range then clear texbox

Re: showing message box if the result of texbox doesn't match with the range then clear te

Re: showing message box if the result of texbox doesn't match with the range then clear te

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions