Help Needed

[helen85]

Hi I am having a little trouble with my code.........here is what I currently have:

Private Sub initfrmCalendar()

  Dim i As Integer    'Used as a counter
  Dim iDay As Integer 'Used to set the day
   
  setStartIndex       'Set the starting index, first textbox to use
  setEndIndex         'Set the ending index, last textbox to use
  clearTextboxes      'Clear the calendar
  
  iDay = 1
  
  'Loop to fill the textboxes with days
  'Also to re-enable the disabled ones
  

  While iDay <= iEndIndex
  

    txtDay(iStartIndex).Text = iDay
    txtDay(iStartIndex).Enabled = True 'Re-enable
    txtDay(iStartIndex).BackColor = vbWhite 'Reset the color
    
    iDay = iDay + 1
    iStartIndex = iStartIndex + 1
    

  Wend
  
  
  disableUnusedBoxes
  

End Sub

Its giving an error msg on the txtDay part, saying "wrong number of arguments or invalid property assignment" the txtDay is currently a button and I what it to loop thou all the buttons, i have a control array txtDay handed coded as I am using vba,

thanx

[vbfbryce]

Shouldn't "txtDay(iStartIndex).Text"

be "txtDay(iStartIndex).Caption" instead?

I don't know if "VBA" is different than "VB" or not on this one...

[si_the_geek]

I am using vba,

VBA and VB6 are significantly different in several ways (particularly controls etc), which is why we have different forums for them - Thread moved from the 'VB6' forum to the 'Office Development/VBA' forum

[emartinho]

Shouldn't "txtDay(iStartIndex).Text"

be "txtDay(iStartIndex).Caption" instead?

I don't know if "VBA" is different than "VB" or not on this one...

Got it in one vbfbryce. Since txtDay is button, then the ".text" should be ".Caption". This is no different than in VB6.

helen85: You should try naming your controls to reflect their type. The name "txtDay" makes it appear that you're dealing with a textbox. Perhaps renaming the control to "cmdDay" or "btnDay" would remove some of the ambiguity.

Cheers.
-EM