Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 combobox change vlue
Hi
Have this Private Sub UserForm_Initialize() Dim myrange As Range Set myrange = Sheets("desti").Range("desti") For Each c In myrange ComboBox1.AddItem c.Value Next Dim murange2 As Range Set myrange2 = Sheets("beregn").Range("fly") For Each a In myrange2 ComboBox2.AddItem a.Value Next End Sub But i have some problems with the combobox2 there get data from Sheets("beregn").Range("fly") The data change after what there are coosen in combox1, its working on the sheet but how do i get the combox2 to select the new data from the sheet hope somone understand me and can help. Alvin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 combobox change vlue
Forget the first
I have this in a sheet =INDIRECT.EXT("'H:\city breaks\priser\europa\["& priskalk!$L$4 &" prisliste.xls]prisliste'!$B$1") I want to change & priskalk!$L$4 & To the value off my combobox in the userform My combo look like this Private Sub UserForm_Initialize() Dim myrange As Range Set myrange = Sheets("desti").Range("desti") For Each c In myrange ComboBox1.AddItem c.Value Next How do i get det value there are chosen in the combobox to the line with my indirect. Alvin "Alvin Hansen" skrev: Hi Have this Private Sub UserForm_Initialize() Dim myrange As Range Set myrange = Sheets("desti").Range("desti") For Each c In myrange ComboBox1.AddItem c.Value Next Dim murange2 As Range Set myrange2 = Sheets("beregn").Range("fly") For Each a In myrange2 ComboBox2.AddItem a.Value Next End Sub But i have some problems with the combobox2 there get data from Sheets("beregn").Range("fly") The data change after what there are coosen in combox1, its working on the sheet but how do i get the combox2 to select the new data from the sheet hope somone understand me and can help. Alvin |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 combobox change vlue
Private Sub Combobox1_click()
Range("priskalk!$L$4").Value = Combobox1.Value End Sub -- Regards, Tom Ogilvy "Alvin Hansen" wrote in message ... Forget the first I have this in a sheet =INDIRECT.EXT("'H:\city breaks\priser\europa\["& priskalk!$L$4 &" prisliste.xls]prisliste'!$B$1") I want to change & priskalk!$L$4 & To the value off my combobox in the userform My combo look like this Private Sub UserForm_Initialize() Dim myrange As Range Set myrange = Sheets("desti").Range("desti") For Each c In myrange ComboBox1.AddItem c.Value Next How do i get det value there are chosen in the combobox to the line with my indirect. Alvin "Alvin Hansen" skrev: Hi Have this Private Sub UserForm_Initialize() Dim myrange As Range Set myrange = Sheets("desti").Range("desti") For Each c In myrange ComboBox1.AddItem c.Value Next Dim murange2 As Range Set myrange2 = Sheets("beregn").Range("fly") For Each a In myrange2 ComboBox2.AddItem a.Value Next End Sub But i have some problems with the combobox2 there get data from Sheets("beregn").Range("fly") The data change after what there are coosen in combox1, its working on the sheet but how do i get the combox2 to select the new data from the sheet hope somone understand me and can help. Alvin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use a vlue of a cell for the sum range | New Users to Excel | |||
separating alpha numeric vlue | Excel Discussion (Misc queries) | |||
wnt to look up fr a vlue in a clmn nd get the avg of the row | Excel Worksheet Functions | |||
Change minimumscale with the change event of a combobox | Excel Programming | |||
combobox change | Excel Programming |