Use variable from object in module with VBA

Question

In object -Sheet2- I've this:

Private Sub Listbox1_Change()
    keuze = Sheet2.Listbox1.Text
End Sub

I want to use the variable keuze in a module, but what I try, it's empty. How can I solve this?

Mrig · Accepted Answer · 2017-09-22 11:33:15Z

2

Declare keuze in module as

Public keuze As String

Then after assigning keuze = Sheet2.Listbox1.Text you can access value of keuze in module also.

By using the Public keyword, variable will be available across all modules and the value of Public variable will preserve until Workbook is closed or reset the Project.

edited Sep 22, 2017 at 11:33

answered Sep 22, 2017 at 11:21

Mrig

11.7k2 gold badges15 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Use variable from object in module with VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related