Excel VBA combobox , Listfill

[dodde]

Hello

i am try to lern how ta add a combobox an listfill / maybe without VBA if that better, i dont know as i am newbie to this

Below is a picture of my Sheet2 "Data", the first colum Colum A i want to show in combobox on Sheet1 "EMVC"

Lets say combobox in Sheet1 "EMVC" is in cell B5 open A3 "SHS 20 / 2" then i want to fill out the rest, i can not figure out how to do

[torachan]

missed the yellow banner at the head of the page, it is a lot easier to manipulate an actual sheet than a picture

[dodde]

Hello

Sorry, i can put Workbbook here to

[Fluff13]

Change the linked cell of the combo to B5 & put this formula in C5 & copy across
=INDEX(Data!B$3:B$144,MATCH($B5,Data!$A$3:$A$144,0))

[dodde]

Hello

Thank you, can i just ask why some use VBA

[Fluff13]

Just depends on the complexity. In this case a simple formula will do what you asked, so (IMO) there is no point in using VBA.

[dodde]

Hello

I must open this again , i have problem with zoom in combobox i also look at this thread "Combobox size and list within keep shrinking"

I did see i can use a formbox, but i can not get this code to work =INDEX(Data!B$3:B$144,MATCH($B5,Data!$A$3:$A$144,0))

Must i use a vba to do this code maybe, i have searced and can not finf any solutions, with a Active -X i get this problem

[Fluff13]

As this is now a totally different question, you will need to start a new thread.
Thanks

[dodde]

Hello

I found this vba and it works, is it posible to make it for all comboboxes or must i du it for each

Please Login or Register  to view this content.

[dodde]

Hello

i see now we answer the same time i will make this solved again