VBA Userform Question - Commandbuttons

[orangefury90]

I think my previous post was too long and confusing...

I can not seem get the below code in red to work. I am trying to change commandbuttons (R1C1, R1C2, R1C3, R1C4 etc) to change their captions to text that is already saved into an array without making a hundreds of lines of code.

Dim button_array(0 To 24, 0 To 2) as string

'Update button captions with information from array
for i = 1 to 5
for j = 1 to 5
update_log_form.R(i)C(j).caption = button_array(i,0)

next j
next i

Thanks in advance!!

 

[orangefury90]

If anyone is interested, I figured it out. Here is the code when deciding if the command button is hidden or not:

Dim button As msforms.CommandButton

For i = 1 To 5

For j = 1 To 5​

Set button = update_log_form.Controls("R" & i & "C" & j)​

button.Visible = True​

Next j​

Next i