I ended up fixing this by using a filter on my array:
'ReDim arrDeviceNames() to trim the "EMPTY DEVICE"
arrNonEmptyDeviceNames = Filter(arrDeviceNames, "EMPTY DEVICE",
False)
Thanks guys,
Matt
On Nov 3, 9:13 am, RemyMaza wrote:
> I have an array of value
I have an array of values that come in off of a form. One of these
values is "Empty Device". Here's the code I'm using to handle that:
Devices = Array(cmb1.Value, cmb2.Value, cmb3.Value, cmb4.Value,
cmb5.Value, cmb6.Value, cmb7.Value)
Now that I have my Devices array, I loop through the number
>
>
> On Mon, Oct 25, 2010 at 6:08 PM, RemyMaza wrote:
> > You have a white text cell of =na() for the month of May. You also
> > need to format the cells into numbers. After those two tweaks, the
> > min & max worked for me.
>
> > Cheers,
> > Matt
>
>
You have a white text cell of =na() for the month of May. You also
need to format the cells into numbers. After those two tweaks, the
min & max worked for me.
Cheers,
Matt
On Oct 25, 12:37 am, Shrinivas Shevde wrote:
> Really talented answer .
> Now I have Another problem.
> For the same data
If I create an UDF and use Dim to create some variables do I have to
make sure by the end of the function these variables are set to =
Nothing
Here's an example:
Function FindRing(rng As Range) As String
Dim cell As Range
Dim strColumn As String
Dim intDelim As Integer
Dim intColC
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
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
If TypeName(c) = sNameC Then
> If c.ListIndex > -1 Then
> ReDim Preserve v(i)
> v(i) = c.Value
> Debug.Print c.Value
> i = i + 1
> End If
> End If
> Next
> not_null_control_list = v
> End Functi
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
.
>
> then put a "X" in A2.
> in B2 I put:
> =deviceform(A2)
>
> them menu then popped up with the row # (2).
> I moved the X to A4, and the popup displayed (4)..
>
> is the rng.Row what you were looking for?
>
> Paul
>
>
>
> - Original Me
I have a simple function that looks at a single cell for it's value.
If it's an X, then i'd like for a form to appear. I'd like to pass
the value rng.row to the form so I can know which row I'm
manipulating. I've failed so far in my attempts to do just that. Any
tips would be awesome.
Function
11 matches
Mail list logo
