Hello and Help:

I wrote VBA code (Excel 2000 SR1) which connected UserForms with
textboxes to worksheet cells. In a moment of insanity, I decided to
also convert this to VB6. Now, after successfully “getting” an existing
Excel Workbook, the ControlSource property is problematic – except
possibly for those cells which were originally null. The Error
encountered is that “Could not set the ControlSource property. Invalid
property value.” Do I need a different syntax for referring to a
Worksheet Cell? There are no spaces or other “unacceptable” characters
in the sheet name. Am I inheriting a restriction? These are UserForms
in the Designer Folder of vb6. They are not VB6 Forms.

As an example:

frmInputCompletion.txtWHwrtRT.ControlSource = xlSheet.Range("C3")

gives an error.

Any help would be greatly appreciated.

Sincerely

John M.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!