View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Forms wont show in VBA.... is this a known bug or do I have a corrupted Excel file ?

Richard,

I don't recall this issue with Excel 5.
However, xl5 used dialog sheets instead of user forms.
So I guess you would say its been there since xl 97 (xl 8).

There are major changes coming in the next XL release (xl 12).
Whether the issue is fixed or compounded has not been mentioned
in any discussions I've seen.

Regards,
Jim Cone
San Francisco, USA


"Richard Finnigan"
wrote in message
...

Richard,

One more thing to keep in mind for the next form you create...
It is very easy to increase the form file size but very difficult to
reduce
the form file size. Removing code or controls does not decrease the
file size proportionally. Therefore, it is best to experiment and test
in a separate dummy/test form before creating your final version.

Jim Cone


Thanks for that though I have to say I am extremely disappionted that Excel
should be so flawed when it comes to handling forms...I havent encountered
these issues in VB6 or Access. Its a shame, is this a long running issue
with Excel ?

Richard