var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: text from combo box
I have combo box in my form which have 2 columns "value" and "text" but "value" is hidden.
I write some code in VBA and I need select only "text" from my combo box, how can I do it using VBA?
Last edited by andrzejfox; 04-03-13 at 10:48.
You can retrieve the content of any column of the selected row using the Column property of a combobox (or a listbox) using:
Dim SomeVariable As Variant
SomeVariable = Me.ComboboxName.Column(x)
- ComboboxName is the name of the combobox
- x is the position of the column, with 0 for the first (leftmost) column.
Have a nice day!