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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200711/1

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

"diglas1 via OfficeKB.com" wrote:

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200711/1

Thanks, give it a go.

JLGWhiz wrote:
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.

--
Message posted via http://www.officekb.com

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

diglas1 wrote:
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]

Help appreciated.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200711/1