ExcelBanter - Macros

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Macros (https://www.excelbanter.com/new-users-excel/4545-macros.html)

Rinyma

Macros

How do I run a macro from a list box?

LanceB

Assuming your listbox contained a,b,c,d as entries

Private Sub ListBox1_Change()
x = ListBox1.Value

Select Case x

Case "a"
"your routine"
Case "b"
"your routine"
Case "c"
"your routine"
Case "d"
"your routine"

End Select

End Sub

"Rinyma" wrote:

How do I run a macro from a list box?

All times are GMT +1. The time now is 02:34 AM.