DannyBOHLEN
02-27-2012, 10:44 AM
Hi :hi:
I have made an application in excel 2010 and, when I was ready to finish it, I had some problems :banghead: , and I strongly wish to fix this: :help
1. I have one textbox (set with multiline property true) which shows me a text (with many paragraphs); I want to print this (simple) text to (default) a printer, ONLY THE TEXT, not the textbox, not the cells, not the sheet, not the workbook !
For example, the textbox, at a certain moment, contained the text ”My text to print” & vbNewLine & ”second line to print”, I want to print to a printer JUST the text ”My text to print / second line to print” and nothing else.
I found a solution for this problem, but I don”t want to use this: I save the text in a text file to my HDD, and after that I should open the file and print this file (also my text).
2. In a (protected) sheet, I have (for example) 10 controls! I want to navigate (CHANGE FOCUS), in a specific order, between these controls with tab key (shift tab) or arrows keys! Why? It”s hard to work only with the mouse!
:friends: Thanks for all in advance! :bow:
I have made an application in excel 2010 and, when I was ready to finish it, I had some problems :banghead: , and I strongly wish to fix this: :help
1. I have one textbox (set with multiline property true) which shows me a text (with many paragraphs); I want to print this (simple) text to (default) a printer, ONLY THE TEXT, not the textbox, not the cells, not the sheet, not the workbook !
For example, the textbox, at a certain moment, contained the text ”My text to print” & vbNewLine & ”second line to print”, I want to print to a printer JUST the text ”My text to print / second line to print” and nothing else.
I found a solution for this problem, but I don”t want to use this: I save the text in a text file to my HDD, and after that I should open the file and print this file (also my text).
2. In a (protected) sheet, I have (for example) 10 controls! I want to navigate (CHANGE FOCUS), in a specific order, between these controls with tab key (shift tab) or arrows keys! Why? It”s hard to work only with the mouse!
:friends: Thanks for all in advance! :bow: