+ Reply to Thread
Results 1 to 5 of 5

call variable from one procedure to in other procedure

  1. #1
    Forum Contributor
    Join Date
    01-06-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    118

    call variable from one procedure to in other procedure

    Hi,

    Pls go through the attachment. In that there are two codes. we need to run , one after another.


    In first code I stored "findstring" variable value some where in the excel sheet. same string i used in the second code. But i want to call that "findstring" from first code to second code.

    regards
    shiva
    Last edited by shiva_raj; 02-20-2017 at 02:21 AM.

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: call variable from one procedure to in other procedure

    You could make findstring a module wide variable.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Forum Contributor
    Join Date
    01-06-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    118

    Re: call variable from one procedure to in other procedure

    Sorry, i could not understand. pls explain clearly.

    Thank you in advance

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: call variable from one procedure to in other procedure

    What's the difference with this thread ??

    http://www.excelforum.com/excel-prog...time-only.html
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  5. #5
    Forum Contributor
    Join Date
    01-06-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    118

    Re: call variable from one procedure to in other procedure

    I thought those are different questions. that is why i wrote queries in different threads.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calling Procedure or Function inside another Procedure - variables problem
    By Rudo123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-22-2015, 03:12 PM
  2. [SOLVED] Create a time delay at end of procedure that will then call on next procedure
    By Clay Shooter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2013, 05:56 AM
  3. Using a call procedure
    By narrowgate88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-07-2010, 10:30 AM
  4. Using a variable calculated in a procedure in another procedure.
    By Trinidad3 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-06-2010, 04:51 AM
  5. [SOLVED] Variable procedure call
    By Art in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-16-2005, 09:20 AM
  6. [SOLVED] Call procedure using variable
    By donbowyer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2005, 05:05 AM
  7. [SOLVED] Call Procedure
    By Ronbo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1