Two Quick Questions: Calling Subs & Text Input boxes

[ph8]

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.

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[ph8]

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.

[Bob Phillips]

Sorry, lost track of that. I will look it up in Google.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ph8" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[ph8]

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 here:
http://www.excelforum.com/showthread.php?t=387116

Thanks again !