G
George Hester
You know, it doesn't seem to matter what "new" thing I try in VBA there is always some aspect that doesn't work. Here is one. This uses some beast called a UserForms collection. It's not that it doesn't work but that the Intellisense is just plain messed up. I wonder if Microsoft thinks it might be a good idea to have products which WORK or just products???
Here is an example:
Make a new form in the Outlook 2002 VBA IDE. Name it frmExcel. Make a new module and name that modExcel. Now in the module enter this Sub:
Sub ShowForm()
Dim x
Load frmExcel
x = UserFoms.Count - 1
UserForms.item(x).Show
Unload frmExcel
End Sub
The trouble here is that the intellisense is just plain messed up and there is no way that I can find to get it to work right. Any ideas? This actually comes from here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;157496
and in these examples intellisense does NOT work for any of them.
Here is an example:
Make a new form in the Outlook 2002 VBA IDE. Name it frmExcel. Make a new module and name that modExcel. Now in the module enter this Sub:
Sub ShowForm()
Dim x
Load frmExcel
x = UserFoms.Count - 1
UserForms.item(x).Show
Unload frmExcel
End Sub
The trouble here is that the intellisense is just plain messed up and there is no way that I can find to get it to work right. Any ideas? This actually comes from here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;157496
and in these examples intellisense does NOT work for any of them.