Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 811
Default 64kb limit to module code

"RB Smissaert" wrote in message
...
Does the same apply to Userforms?
Just exported one and the .frm file is 90 Kb and the .frx file is 80 Kb.
It does actually sometimes show minor abberations, but sofar nothing major
to worry about.


That's a very good question. UserForms didn't even exist when this
problem first appeared, so I don't know if they are handled differently from
standard modules or not. I keep my own UserForm code within the 64KB limit
out of habit, so I haven't had the opportunity to test the size limit with
them. Based on postings here, having too many controls on a UserForm seems
to be a much more common problem then having to much code in them.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
code module? Kat Excel Worksheet Functions 2 January 10th 09 03:10 AM
code won't run from a module Geoff Excel Discussion (Misc queries) 3 February 20th 07 08:08 PM
Unprotect Code Module in Code Damien Excel Discussion (Misc queries) 2 April 18th 06 03:10 PM
code in module A to not execute a Worksheet_SelectionChange sub of another module Jack Sons Excel Discussion (Misc queries) 4 December 11th 05 11:52 PM
copying vba code to a standard code module 1vagrowr Excel Discussion (Misc queries) 2 November 23rd 05 04:00 PM


All times are GMT +1. The time now is 03:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"