I will try it and reply as soon as possible
This is the project excel.
My goal is this,
Get the values (A19:A41) from the selected sheet which is in the Combobox on Sheet1.
and check that if
* it is < 999 then paste the cell value to Sheet1 K9 and paste "Hz" to Sheet1 L9.
*it is > 999 then divide the cell value by 1000 and paste it to Sheet1 K9 and write "kHz" to Sheet1 L9.
and this will be applied to all rows between (A19:A41).
I think the variable wb1 has defined as the user select the sheet from the combobox.
Hello to all,
I am working on a project that you have measurement results on the sheets and on the main sheet you can see these results with combobox selection.
I tried to do something but I have compile error 1004 messageCode
- Private Sub ComboBox1_Change()
- 'Updateby Extendoffice
- If ComboBox1.ListIndex > -1 Then
- Application.DisplayAlerts = False
- wb1 = ComboBox1.Text
- Dim i As Long
- Dim y As Long
- y = 9
- For i = 19 To 40
- Worksheets(wb1).Range("A", i).Copy
- Worksheets("Sheet1").Range("L", y).PasteSpecial Paste:=xlPasteValues
- y = y + 1
- Next i
- End If
- End Sub
- Private Sub ComboBox1_DropButtonClick()
- Dim xSheet As Worksheet
- On Error Resume Next
- Application.ScreenUpdating = False
- Application.EnableEvents = False
- If ComboBox1.ListCount <> ThisWorkbook.Sheets.Count Then
- For Each xSheet In ThisWorkbook.Sheets
- ComboBox1.AddItem xSheet.Name
- Next xSheet
- End If
- Application.EnableEvents = True
- Application.ScreenUpdating = True
- End Sub
This my project template. When I select the sheet on the dropdownList, the measurement values should brought down to the dropdown list
Hello all from newer,
I need your help with my project if possible.
My project is like below :
I will have a workbook which has maximum 25 sheets.
On the main sheet, I will have a dropdown list which contains the sheet names and these names can be automatically updated when adding or deleting the sheets.
When I select one sheet name on the dropdown list, some values in selected sheet will come to the main sheet.
Is it possible and can you help me about this project?