copy coding

[charly1]

Hi all

I'm pretty new to excel and don't even know if my question is a simple one or not, although any help would be greatly appreciated.

cb.xlsm

drive.google.com

I have attached a user form which contains a searchable combo box [not my creation]. I would like to insert into this user form a separate combo box which utilizes the same coding except that the source data for each should be different. Obviously both combo boxes have to be able to work independently of each other, despite much of their coding being identical.

I cannot seem to be able to work this out on my own.

Thanks ever so much for any help

 

[My Aswer Is This]

I never click on links like this.
So, show me the code you have in the combobox.
And or the other code that performs the task you want to achieve.

One combobox can do a lot of things.
Like if choose the value "One" in the combobox.
A script in the combobox could copy the range "One."
And paste that range somewhere else.
Or if you choose "Two" in the combobox something else could happen.
All of this with just one combobox.

Hi all

I'm pretty new to excel and don't even know if my question is a simple one or not, although any help would be greatly appreciated.

cb.xlsm

drive.google.com

I have attached a user form which contains a searchable combo box [not my creation]. I would like to insert into this user form a separate combo box which utilizes the same coding except that the source data for each should be different. Obviously both combo boxes have to be able to work independently of each other, despite much of their coding being identical.

I cannot seem to be able to work this out on my own.

Thanks ever so much for any help

 

[charly1]

I have already just copied the code over and renamed all the varibles to make them unique. Its not really a solution to the problem, however it works for me.

Ime pretty new here so Ime not sure if in my case i am supposed to mark my query as solved or not.

Sorry for bothering you.