LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 573
Default Code in userform/worksheet vs. in Module

In another thread, I asked about using GoTos. Got some great feedback.
But some of what I was told seems contrary to what I have read
elsewhere. I got the impression somewhere in my reading on VBA coding
that it's better to minimize the code in the userforms/worksheets and
keep as much of it as possible in Modules. Easier to find and access,
something like that. Do others here agree, or do you just put the code
wherever? Is there an advantage to using a Call from the userform to a
module, or just do even long, involved code in the userform/worksheet?

 
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
Where?Worksheet code module or Worksheet_SelectionChange event han Kenzie Excel Worksheet Functions 4 January 30th 06 09:41 PM
Run worksheet module code from workbook module? keithb Excel Programming 1 August 14th 05 04:04 AM
Create a newworksheet with VBA code and put VBA code in the new worksheet module ceshelman Excel Programming 4 June 15th 05 04:37 PM
Moved code from worksheet to module Phil Floyd Excel Programming 4 March 23rd 05 08:49 PM
Problem copying worksheet containing code module Basie[_2_] Excel Programming 1 September 3rd 03 12:28 AM


All times are GMT +1. The time now is 11:42 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"