excel question vb

[LabR@t]

how do i use vb behinf a button so

when clicked it checks an 10 cells for the values in an array

ie

dim myArray as variant(5)

myArray(0) =val1
myArray(1) = val2

 

[namnoc]

Hi I checked for you and this just through me as it used to be simple, but now is hidden by default in the latest Excel. Go into the funny icon in the top left, select excel options and make sure the developer tab is included in the ribbon.

Now it is simple, select developer, then insert and I am sure you can do it from there

 

[LabR@t]

nevermind i sussed it