| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SIMPLE UserForm w/ 2 OPTION BUTTONS
I can see that I have some distance to go to proceed up the learnin curve. Tom, I assume you meant "Public Const sSTRING = "ABCD". And doesn' the code need a STRING1 and a STRING2? Chuckles12 -- Chuckles12 ----------------------------------------------------------------------- Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494 View this thread: http://www.excelforum.com/showthread.php?threadid=26805 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SIMPLE UserForm w/ 2 OPTION BUTTONS
In this inst
-- HTH RP "Chuckles123" wrote in message ... I can see that I have some distance to go to proceed up the learning curve. Tom, I assume you meant "Public Const sSTRING = "ABCD". And doesn't the code need a STRING1 and a STRING2? Chuckles123 -- Chuckles123 ------------------------------------------------------------------------ Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 View this thread: http://www.excelforum.com/showthread...hreadid=268057 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SIMPLE UserForm w/ 2 OPTION BUTTONS
In this instance, it should be Public as it is being referred to in another
module, the form class. But as Tom shows, it can be defined as just Const if only used in that module. -- HTH RP "Chuckles123" wrote in message ... I can see that I have some distance to go to proceed up the learning curve. Tom, I assume you meant "Public Const sSTRING = "ABCD". And doesn't the code need a STRING1 and a STRING2? Chuckles123 -- Chuckles123 ------------------------------------------------------------------------ Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 View this thread: http://www.excelforum.com/showthread...hreadid=268057 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SIMPLE UserForm w/ 2 OPTION BUTTONS
When I posted, I only saw the post asking about constants - I wasn't in
threaded mode - so I thought it was a standalone question. -- Regards, Tom Ogilvy "Bob Phillips" wrote in message ... In this instance, it should be Public as it is being referred to in another module, the form class. But as Tom shows, it can be defined as just Const if only used in that module. -- HTH RP "Chuckles123" wrote in message ... I can see that I have some distance to go to proceed up the learning curve. Tom, I assume you meant "Public Const sSTRING = "ABCD". And doesn't the code need a STRING1 and a STRING2? Chuckles123 -- Chuckles123 ------------------------------------------------------------------------ Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 View this thread: http://www.excelforum.com/showthread...hreadid=268057 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SIMPLE UserForm w/ 2 OPTION BUTTONS
Question Tom. Do you find non-threaded mode has any advantages? I always use
threaded, and am always on the lookout for better ways. Cheers Bob "Tom Ogilvy" wrote in message ... When I posted, I only saw the post asking about constants - I wasn't in threaded mode - so I thought it was a standalone question. -- Regards, Tom Ogilvy "Bob Phillips" wrote in message ... In this instance, it should be Public as it is being referred to in another module, the form class. But as Tom shows, it can be defined as just Const if only used in that module. -- HTH RP "Chuckles123" wrote in message ... I can see that I have some distance to go to proceed up the learning curve. Tom, I assume you meant "Public Const sSTRING = "ABCD". And doesn't the code need a STRING1 and a STRING2? Chuckles123 -- Chuckles123 ------------------------------------------------------------------------ Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 View this thread: http://www.excelforum.com/showthread...hreadid=268057 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SIMPLE UserForm w/ 2 OPTION BUTTONS
I use threaded mode almost all the time. I only go to unthreaded mode
because there are some questions that never appear in threaded mode (haven't figured out what is special). I also use it sometimes just to see if there is a recent post going back to a very old question or to see what old questions are still being answered or generating activity. -- Regards, Tom Ogilvy "Bob Phillips" wrote in message ... Question Tom. Do you find non-threaded mode has any advantages? I always use threaded, and am always on the lookout for better ways. Cheers Bob "Tom Ogilvy" wrote in message ... When I posted, I only saw the post asking about constants - I wasn't in threaded mode - so I thought it was a standalone question. -- Regards, Tom Ogilvy "Bob Phillips" wrote in message ... In this instance, it should be Public as it is being referred to in another module, the form class. But as Tom shows, it can be defined as just Const if only used in that module. -- HTH RP "Chuckles123" wrote in message ... I can see that I have some distance to go to proceed up the learning curve. Tom, I assume you meant "Public Const sSTRING = "ABCD". And doesn't the code need a STRING1 and a STRING2? Chuckles123 -- Chuckles123 ------------------------------------------------------------------------ Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 View this thread: http://www.excelforum.com/showthread...hreadid=268057 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SIMPLE UserForm w/ 2 OPTION BUTTONS
Thanks Tom.
I frequently see responses in the threaded mode to another post that I don't see, I guess that is one of the situations you are referring to. Bob "Tom Ogilvy" wrote in message ... I use threaded mode almost all the time. I only go to unthreaded mode because there are some questions that never appear in threaded mode (haven't figured out what is special). I also use it sometimes just to see if there is a recent post going back to a very old question or to see what old questions are still being answered or generating activity. -- Regards, Tom Ogilvy "Bob Phillips" wrote in message ... Question Tom. Do you find non-threaded mode has any advantages? I always use threaded, and am always on the lookout for better ways. Cheers Bob "Tom Ogilvy" wrote in message ... When I posted, I only saw the post asking about constants - I wasn't in threaded mode - so I thought it was a standalone question. -- Regards, Tom Ogilvy "Bob Phillips" wrote in message ... In this instance, it should be Public as it is being referred to in another module, the form class. But as Tom shows, it can be defined as just Const if only used in that module. -- HTH RP "Chuckles123" wrote in message ... I can see that I have some distance to go to proceed up the learning curve. Tom, I assume you meant "Public Const sSTRING = "ABCD". And doesn't the code need a STRING1 and a STRING2? Chuckles123 -- Chuckles123 ------------------------------------------------------------------------ Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 View this thread: http://www.excelforum.com/showthread...hreadid=268057 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Option Buttons/Radio Buttons | New Users to Excel | |||
| option buttons | Excel Worksheet Functions | |||
| SIMPLE UserForm w/ 2 OPTION BUTTONS | Excel Programming | |||
| SIMPLE UserForm w/ 2 OPTION BUTTONS | Excel Programming | |||
| option buttons | Excel Programming | |||
![Chuckles123[_40_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
