Howdie all.
I've made a user form, and set it up with some combo boxes.
Presently, my equations are asking for the input for 4 comboboxes. If a
combobox is empty, it still inputs a blank value.

I'd like to set it up so that if a value is not chosen for a combo box, it
leaves that blank value out of the final input.

Presently my equation reads:

ActiveCell.value = Me.ComboBox1.value & Chr(10) & Me.ComboBox2.value &
Chr(10) & Me.ComboBox3.value & Chr(10) & Me.ComboBox4.value

For example, what I've got is combobox1 has a value, and then combobox2 and
3 are blank, then combobox4 has a value.
Instead of placing two blanks in the input, I'd like it to only have the
values from 1 and 4 input.
I.e.,
Instead of
A


D
I'd like
A
D

How would I accomplish that?
Thank you in advance for your helps.
Best.

s = IIf(Me.ComboBox1.Value = "", "", Me.ComboBox1.Value & Chr(10)) & _
IIf(Me.ComboBox2.Value = "", "", Me.ComboBox2.Value & Chr(10)) & _
IIf(Me.ComboBox3.Value = "", "", Me.ComboBox3.Value & Chr(10)) & _
IIf(Me.ComboBox4.Value = "", "", Me.ComboBox4.Value & Chr(10))

regards
r

Il mio ultimo lavoro ...
http://excelvba.altervista.org/blog/...ternative.html


"Steve" wrote:

> Howdie all.
> I've made a user form, and set it up with some combo boxes.
> Presently, my equations are asking for the input for 4 comboboxes. If a
> combobox is empty, it still inputs a blank value.
>
> I'd like to set it up so that if a value is not chosen for a combo box, it
> leaves that blank value out of the final input.
>
> Presently my equation reads:
>
> ActiveCell.value = Me.ComboBox1.value & Chr(10) & Me.ComboBox2.value &
> Chr(10) & Me.ComboBox3.value & Chr(10) & Me.ComboBox4.value
>
> For example, what I've got is combobox1 has a value, and then combobox2 and
> 3 are blank, then combobox4 has a value.
> Instead of placing two blanks in the input, I'd like it to only have the
> values from 1 and 4 input.
> I.e.,
> Instead of
> A
>
>
> D
> I'd like
> A
> D
>
> How would I accomplish that?
> Thank you in advance for your helps.
> Best.

Howdee R.
Thank you for your response.
While this works, it does exactly what I have already-- inputs a space
between values for blank inputs.
However, the inputs vary from instance to instance.
Example, once I'll select 2 values on my first input set. For my second
input set I'll select 1 value. Then, for my third, I'll also select one value.
On the first input set it'll only input one blank beyond the two choices I
made. On the second input set it'll place all spacing, and values. But on the
3rd input, it'll only place the value chosen with no spacing.
And this varies from use to use-- it's inconsistent in its placement of the
spaces that I'm trying to avoid.
Again, thank you for your helps.


"r" wrote:

> s = IIf(Me.ComboBox1.Value = "", "", Me.ComboBox1.Value & Chr(10)) & _
> IIf(Me.ComboBox2.Value = "", "", Me.ComboBox2.Value & Chr(10)) & _
> IIf(Me.ComboBox3.Value = "", "", Me.ComboBox3.Value & Chr(10)) & _
> IIf(Me.ComboBox4.Value = "", "", Me.ComboBox4.Value & Chr(10))
>
> regards
> r
>
> Il mio ultimo lavoro ...
> http://excelvba.altervista.org/blog/...ternative.html
>
>
> "Steve" wrote:
>
> > Howdie all.
> > I've made a user form, and set it up with some combo boxes.
> > Presently, my equations are asking for the input for 4 comboboxes. If a
> > combobox is empty, it still inputs a blank value.
> >
> > I'd like to set it up so that if a value is not chosen for a combo box, it
> > leaves that blank value out of the final input.
> >
> > Presently my equation reads:
> >
> > ActiveCell.value = Me.ComboBox1.value & Chr(10) & Me.ComboBox2.value &
> > Chr(10) & Me.ComboBox3.value & Chr(10) & Me.ComboBox4.value
> >
> > For example, what I've got is combobox1 has a value, and then combobox2 and
> > 3 are blank, then combobox4 has a value.
> > Instead of placing two blanks in the input, I'd like it to only have the
> > values from 1 and 4 input.
> > I.e.,
> > Instead of
> > A
> >
> >
> > D
> > I'd like
> > A
> > D
> >
> > How would I accomplish that?
> > Thank you in advance for your helps.
> > Best.