How to update data in a Control ?

[diglas1 via OfficeKB.com]

Been messing around with very basic controls but frustratingly unable to find
a post showing how to update a value initially displayed in a Control box.
I have about 12 items of standing data, held in variables, with values which
will not often be changed.
I want to display these to the user in a list with tick boxes against each in
case an update is wanted.
Then I want to update the field(s) and save to the variable.
I suspect it can be done with a Combobox, but maybe also need Listbox(es).

Help appreciated.

 

[Guest]

Using ListIndex() is one way. You can add, delete, replace. Check it out in
VBA help files.

 

[diglas1 via OfficeKB.com]

Thanks, give it a go.

Using ListIndex() is one way. You can add, delete, replace. Check it out in
VBA help files.

Been messing around with very basic controls but frustratingly unable to find
a post showing how to update a value initially displayed in a Control box.

[quoted text clipped - 6 lines]

Help appreciated.

 

[diglas1 via OfficeKB.com]

Thanks very much, the Help examples are just what I needed.

Thanks, give it a go.

Using ListIndex() is one way. You can add, delete, replace. Check it out in
VBA help files.

[quoted text clipped - 4 lines]