| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two Quick Questions: Calling Subs & Text Input boxes
Hey folks. Two quick questions I have. 1. How do you call a sub from a different worksheet (from "This Module" to a sub on "Sheet 1")? 2. Is there a way to be able to Tab between input text boxes in excel? Thank in advanced guys. I appreciate it. -- ph8 ------------------------------------------------------------------------ ph8's Profile: http://www.excelforum.com/member.php...o&userid=19871 View this thread: http://www.excelforum.com/showthread...hreadid=398078 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Two Quick Questions: Calling Subs & Text Input boxes
1. You need to make the procedure public and precede it with the sheetname
Sheet1.Worksheet_Change(Range("A1")) 2. See my response in http://tinyurl.com/dvjfs -- HTH RP (remove nothere from the email address if mailing direct) "ph8" wrote in message ... Hey folks. Two quick questions I have. 1. How do you call a sub from a different worksheet (from "This Module" to a sub on "Sheet 1")? 2. Is there a way to be able to Tab between input text boxes in excel? Thank in advanced guys. I appreciate it. -- ph8 ------------------------------------------------------------------------ ph8's Profile: http://www.excelforum.com/member.php...o&userid=19871 View this thread: http://www.excelforum.com/showthread...hreadid=398078 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Two Quick Questions: Calling Subs & Text Input boxes
Great. Thanks Bob, exactly what I needed. Thanks ! PS: While I have your attention, is there any chance we (well, mostly you) can finish up the work in the other thread I made? The one having to do with folder searching and correcting the output of code already written. -- ph8 ------------------------------------------------------------------------ ph8's Profile: http://www.excelforum.com/member.php...o&userid=19871 View this thread: http://www.excelforum.com/showthread...hreadid=398078 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Two Quick Questions: Calling Subs & Text Input boxes
Sorry, lost track of that. I will look it up in Google.
-- HTH RP (remove nothere from the email address if mailing direct) "ph8" wrote in message ... Great. Thanks Bob, exactly what I needed. Thanks ! PS: While I have your attention, is there any chance we (well, mostly you) can finish up the work in the other thread I made? The one having to do with folder searching and correcting the output of code already written. -- ph8 ------------------------------------------------------------------------ ph8's Profile: http://www.excelforum.com/member.php...o&userid=19871 View this thread: http://www.excelforum.com/showthread...hreadid=398078 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Two Quick Questions: Calling Subs & Text Input boxes
Awsome! Thanks yet again Bob. I really appreciate your time. I don't know how you normally view these messages, but I do using forum software. The link to that particular thread is he http://www.excelforum.com/showthread.php?t=387116 Thanks again ! -- ph8 ------------------------------------------------------------------------ ph8's Profile: http://www.excelforum.com/member.php...o&userid=19871 View this thread: http://www.excelforum.com/showthread...hreadid=398078 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Correct Syntax for Calling other Subs | Excel Programming | |||
| Calling Text Boxes from a sheet | Excel Programming | |||
| Calling subs from different workbooks | Excel Programming | |||
| calling subs | Excel Programming | |||
| calling private subs | Excel Programming | |||
![ph8[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
