| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
whats it do
Have never used compile and haven't read any in my books. Do not understand
what it does. Have put together a program for parade. Don't know if compile is something I should do to this or not. any suggestions? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
whats it do
This cannot be simply explained.
Actually compilation make your code run faster in terms of processing. However if you excel work involves stupid / inefficient design, compile cannot help much. About portability (before making it add-in, xla file), if you compile it, for other people to use it, they need Excel application as well (i mean it cannot be run standalone like exe). It probably a good way for you to check if you are doing all the variables right... i think it is a necessary step for creating add-ins "Curt" wrote: Have never used compile and haven't read any in my books. Do not understand what it does. Have put together a program for parade. Don't know if compile is something I should do to this or not. any suggestions? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
whats it do
Thank You for info will expermint Dont know if I have done it all right but
I've tried Thanks Again "Leung" wrote: This cannot be simply explained. Actually compilation make your code run faster in terms of processing. However if you excel work involves stupid / inefficient design, compile cannot help much. About portability (before making it add-in, xla file), if you compile it, for other people to use it, they need Excel application as well (i mean it cannot be run standalone like exe). It probably a good way for you to check if you are doing all the variables right... i think it is a necessary step for creating add-ins "Curt" wrote: Have never used compile and haven't read any in my books. Do not understand what it does. Have put together a program for parade. Don't know if compile is something I should do to this or not. any suggestions? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
whats it do
Curt, The short explanation is that compiling your VBA code translates it into code that your computer can read and execute. This is done automatically if you don't do it. Also, if it won't compile it will not run and you had better fix it. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Curt" wrote in message Have never used compile and haven't read any in my books. Do not understand what it does. Have put together a program for parade. Don't know if compile is something I should do to this or not. any suggestions? Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
whats it do
It does it on its own? Suprise to me. So if I follow if I run compile and it
doesn't work. Then some of my code is out of place. Thanks "Jim Cone" wrote: Curt, The short explanation is that compiling your VBA code translates it into code that your computer can read and execute. This is done automatically if you don't do it. Also, if it won't compile it will not run and you had better fix it. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Curt" wrote in message Have never used compile and haven't read any in my books. Do not understand what it does. Have put together a program for parade. Don't know if compile is something I should do to this or not. any suggestions? Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
whats it do
I use it to debug my code. If there's a syntax error (or undeclared variable),
then I'll get errors in the compile. You can read some notes by Don Baarns at about what compiling means to VBA: http://archive.baarns.com/excel/develop/vbaperfm.asp And if you're interested in cleaning your code, try Rob Bovey's code cleaner: You can find it he http://www.appspro.com/ or directly http://www.appspro.com/Utilities/CodeCleaner.htm Curt wrote: Have never used compile and haven't read any in my books. Do not understand what it does. Have put together a program for parade. Don't know if compile is something I should do to this or not. any suggestions? Thanks -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
whats it do
Thanks to all for smarting me up. Now I get it. Tried on one procedure and
found var not declared. Would someone advise as to what I should call a option button. Also due to my learning curve. I have buttons numbered from 1-27. Is it possible to renumber these buttons as total i have maybe 10. Thanks Again "Dave Peterson" wrote: I use it to debug my code. If there's a syntax error (or undeclared variable), then I'll get errors in the compile. You can read some notes by Don Baarns at about what compiling means to VBA: http://archive.baarns.com/excel/develop/vbaperfm.asp And if you're interested in cleaning your code, try Rob Bovey's code cleaner: You can find it he http://www.appspro.com/ or directly http://www.appspro.com/Utilities/CodeCleaner.htm Curt wrote: Have never used compile and haven't read any in my books. Do not understand what it does. Have put together a program for parade. Don't know if compile is something I should do to this or not. any suggestions? Thanks -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
whats it do
Are these on a worksheet or on a userform?
If they're on a worksheet, are they optionbuttons from the control toolbox toolbar or from the Forms toolbar? If you wanted a macro to do the renaming, the code would be different. But since there's only 10 optionbuttons, you can do them manually. You can select the optionbutton and then just type the new name in the namebox (to the left of the formulabar). If the optionbuttons are from the Control Toolbox toolbar, then you'll have to be in design mode first. As for naming them, you can choose any name that's valid. But if you're going to refer to them later on, using something mnemonically significant would be best. But if you're using a linked cell to get the status, maybe it's not too important -- I do like naming shapes based on their position in the worksheet: OptBtn_A1 (if it's always in A1) Curt wrote: Thanks to all for smarting me up. Now I get it. Tried on one procedure and found var not declared. Would someone advise as to what I should call a option button. Also due to my learning curve. I have buttons numbered from 1-27. Is it possible to renumber these buttons as total i have maybe 10. Thanks Again "Dave Peterson" wrote: I use it to debug my code. If there's a syntax error (or undeclared variable), then I'll get errors in the compile. You can read some notes by Don Baarns at about what compiling means to VBA: http://archive.baarns.com/excel/develop/vbaperfm.asp And if you're interested in cleaning your code, try Rob Bovey's code cleaner: You can find it he http://www.appspro.com/ or directly http://www.appspro.com/Utilities/CodeCleaner.htm Curt wrote: Have never used compile and haven't read any in my books. Do not understand what it does. Have put together a program for parade. Don't know if compile is something I should do to this or not. any suggestions? Thanks -- Dave Peterson -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
whats it do
These are on user form In the properties page at top it says name is this
what you mean by formula bar. When I view code and click on th option button am asked to view code or properties. This is where I am ok. From forms toolbar not active X controls. Useiong option explicd asked to declare optionbutton1 not defined. Would all need to be defined. also defined as what. All buttons have one thing to do. Ain't smart enought to do more than one thing at a time. Do know this many of those who volunteer for the Vet's Day parade are looking forward for this program. I can not express enough my gratuide to those of you who answer this forum. Will expermint with names and see what happens. Thank You "Dave Peterson" wrote: Are these on a worksheet or on a userform? If they're on a worksheet, are they optionbuttons from the control toolbox toolbar or from the Forms toolbar? If you wanted a macro to do the renaming, the code would be different. But since there's only 10 optionbuttons, you can do them manually. You can select the optionbutton and then just type the new name in the namebox (to the left of the formulabar). If the optionbuttons are from the Control Toolbox toolbar, then you'll have to be in design mode first. As for naming them, you can choose any name that's valid. But if you're going to refer to them later on, using something mnemonically significant would be best. But if you're using a linked cell to get the status, maybe it's not too important -- I do like naming shapes based on their position in the worksheet: OptBtn_A1 (if it's always in A1) Curt wrote: Thanks to all for smarting me up. Now I get it. Tried on one procedure and found var not declared. Would someone advise as to what I should call a option button. Also due to my learning curve. I have buttons numbered from 1-27. Is it possible to renumber these buttons as total i have maybe 10. Thanks Again "Dave Peterson" wrote: I use it to debug my code. If there's a syntax error (or undeclared variable), then I'll get errors in the compile. You can read some notes by Don Baarns at about what compiling means to VBA: http://archive.baarns.com/excel/develop/vbaperfm.asp And if you're interested in cleaning your code, try Rob Bovey's code cleaner: You can find it he http://www.appspro.com/ or directly http://www.appspro.com/Utilities/CodeCleaner.htm Curt wrote: Have never used compile and haven't read any in my books. Do not understand what it does. Have put together a program for parade. Don't know if compile is something I should do to this or not. any suggestions? Thanks -- Dave Peterson -- Dave Peterson |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
whats it do
There's a difference between creating a "form" on a worksheet and a userform
found inside the VBE--the userform inside the VBE would look a lot like the dialog that you see when you use Tools|Options. If they are optionbuttons from the Forms toolbar that are placed on the worksheet, then you won't see "view code". I think you'll have to clarify again. Curt wrote: These are on user form In the properties page at top it says name is this what you mean by formula bar. When I view code and click on th option button am asked to view code or properties. This is where I am ok. From forms toolbar not active X controls. Useiong option explicd asked to declare optionbutton1 not defined. Would all need to be defined. also defined as what. All buttons have one thing to do. Ain't smart enought to do more than one thing at a time. Do know this many of those who volunteer for the Vet's Day parade are looking forward for this program. I can not express enough my gratuide to those of you who answer this forum. Will expermint with names and see what happens. Thank You "Dave Peterson" wrote: Are these on a worksheet or on a userform? If they're on a worksheet, are they optionbuttons from the control toolbox toolbar or from the Forms toolbar? If you wanted a macro to do the renaming, the code would be different. But since there's only 10 optionbuttons, you can do them manually. You can select the optionbutton and then just type the new name in the namebox (to the left of the formulabar). If the optionbuttons are from the Control Toolbox toolbar, then you'll have to be in design mode first. As for naming them, you can choose any name that's valid. But if you're going to refer to them later on, using something mnemonically significant would be best. But if you're using a linked cell to get the status, maybe it's not too important -- I do like naming shapes based on their position in the worksheet: OptBtn_A1 (if it's always in A1) Curt wrote: Thanks to all for smarting me up. Now I get it. Tried on one procedure and found var not declared. Would someone advise as to what I should call a option button. Also due to my learning curve. I have buttons numbered from 1-27. Is it possible to renumber these buttons as total i have maybe 10. Thanks Again "Dave Peterson" wrote: I use it to debug my code. If there's a syntax error (or undeclared variable), then I'll get errors in the compile. You can read some notes by Don Baarns at about what compiling means to VBA: http://archive.baarns.com/excel/develop/vbaperfm.asp And if you're interested in cleaning your code, try Rob Bovey's code cleaner: You can find it he http://www.appspro.com/ or directly http://www.appspro.com/Utilities/CodeCleaner.htm Curt wrote: Have never used compile and haven't read any in my books. Do not understand what it does. Have put together a program for parade. Don't know if compile is something I should do to this or not. any suggestions? Thanks -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| whats wrong with this? | Excel Discussion (Misc queries) | |||
| Whats the best way to... | Excel Worksheet Functions | |||
| Whats the best way to... | Excel Worksheet Functions | |||
| Whats the best way to... | Excel Worksheet Functions | |||
| Whats Wrong with this?? | Excel Worksheet Functions | |||
Hybrid Mode
