Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: pcmedic411
- Order by date
-
Lining up dollar signs($)
Thanks for your help David. When I use the format you suggest I get a type mismatch error. I have even tried using the **$ format and that doesn't give me the output I want. Chuck- pcmedic411
- Post #4
- Forum: QBasic
-
Excel - Same Code, diferent files
Don't use a text file, try saving this "code.txt" as a template(.xlt). Then in the VBProject of each workbook you are using the "code.txt" macros in, reference the template file. Then you only have to update the code in the template, and are able to run the code in any...- pcmedic411
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to enter a complex concatenation formula
Hello jaks999, Did you record the formula entry with the macro recorder? VBA formula debugging tip- If your formula entered in VBA gives an error, perform the following steps: Enter the formula in excel, and if you get the correct result then start the macro recorder and click in the formula...- pcmedic411
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Lining up dollar signs($)
Hi, I am having trouble lining up dollar signs. Here is my code: PRINT USING "& & $####,.## $####,.## $####,.##"; NAME$; TAB(18); DEPT$; TAB(34); BONUS; TAB(48); LOONGBONUS; TAB(66); MOEARNINGS Now I thought that would line up all the signs, but it puts the signs in the end of the...- pcmedic411
- Thread
- Replies: 4
- Forum: QBasic
