If statement to change Combo box's Row-source?

**subbby** · 08-24-2012, 04:03 PM

Can I change the Rowsourse of a combox based on a value.

My attempt :

Using IF statement
to get a clear idea, pls view attached picture1.png and xl sheet.

Following was the code I tried :

Please Login or Register  to view this content.

Thanks,

**Cutter** · 08-24-2012, 05:41 PM

@ subbby

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

**subbby** · 08-24-2012, 10:49 PM

@Cutter
M sorry. Very sorry. Will keep that in mind for sure, next time

Thanks...

**nilem** · 08-25-2012, 02:11 AM

Hi, Subbby. Try following example.
Select "Manufacturing" or "Vendor" on the form in the file "Копия copying" and click OK.
Pre-extract the archive to a separate folder on disk.

**subbby** · 08-28-2012, 09:43 AM

@Nilem

Thank you very much. But I do have the following doubts. (m just 4 months old to VBA programming)

Please Login or Register  to view this content.

I did not understand the following things :

Range A1 :- didn't understand its relation in this object's code. Went abck to sheet1 of worksheet. But found nothing in Range A1
ToArr : - is ToArr a syntax or is it a dummy variable that u storing the formula which u are later on calling in the combo box ?

I do have other doubts in Module 1's code. Will ask after I understand this. Thanks again

**subbby** · 08-28-2012, 10:10 AM

Also,

I had other combo box that were dependent on the values selected on combobox1. Could you just show me an example of how to have the other combo box also to change their values based on the values of the previous combobox.

My attempts :