I'm a bit sketchy on Class Modules, so going through the code, I was a
bit lost. However you posted a sample which is extremely cool. I'm
going to work through that and see if I can decipher it.
I'm so glad I've found this forum. Thanks for all of your help!
Cheers,
Matt
On Oct 20, 6:49 pm, ro
attack the sample file
regards
r
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/g
2010/10/20 RemyMaza
> That works fantastic. It has some problems with how my form works
> though. Let's say for all 7 combo-boxes, the user can only select
> values in order. So if I need 4 devices added, I can't pick from the
> first two and then jump to combo box 5 and 6 to complete the form
bject is not yet defined, set the focus to the first undefined object.
>
> Paul
>
>
>
> - Original Message
> > From: RemyMaza
> > To: MS EXCEL AND VBA MACROS
> > Sent: Wed, October 20, 2010 9:39:03 AM
> > Subject: Re: $$Excel-Macros$$ Dynamically a
fined.
If an object is not yet defined, set the focus to the first undefined object.
Paul
- Original Message
> From: RemyMaza
> To: MS EXCEL AND VBA MACROS
> Sent: Wed, October 20, 2010 9:39:03 AM
> Subject: Re: $$Excel-Macros$$ Dynamically assign values to an array u
That works fantastic. It has some problems with how my form works
though. Let's say for all 7 combo-boxes, the user can only select
values in order. So if I need 4 devices added, I can't pick from the
first two and then jump to combo box 5 and 6 to complete the form. I
need to force the entries
try in a form add some combobox and a button
and add this code:
Option Explicit
Private Sub CommandButton1_Click()
Dim v
v = not_null_control_list()
MsgBox Join(v, ";")
End Sub
Private Sub UserForm_Initialize()
Dim c As MSForms.Control
Dim v
'for example add same value to all combobox
v = Array(1
I have a form with 7 combo boxes on it and I'd like to take the values
from the selections and store the value into an array. Some
background: The first two combo boxes must be selected otherwise the
form should not do anything. As long as the first two equal a value,
the rest of them *could* be
