View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
choco140 choco140 is offline
external usenet poster
 
Posts: 4
Default Concatanate variable name

I got four control on an userform named Date1, Date2, Date3 and Date4.
I am trying to fill them in with this small macro, it doesn't work
because my concatenation doesn't seem to be properly set up...

Sub Test
For i = 1 to 4
Date & i &.value = Range("A" & i).Value
Next i
End Sub

I got an error for "Date & i &.value", any idea how to solve this?

Thanks.