+ Reply to Thread
Results 1 to 6 of 6

Problem with Call command?

  1. #1
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Problem with Call command?

    Hi,

    I'm trying to introduce a call command to fire a different procedure upon change of selection:

    Please Login or Register  to view this content.
    Am I allowed to do this as it doesn't work. Cheers

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Problem with Call command?

    Yes, you can do that (which is not to say that you should). What does "it doesn't work" mean?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: Problem with Call command?

    I'd like to activate the ComboBox36_Change when ComboBox31's value is "HUBAHH04" I wasn't sure whether this could be done or whether its position in the code was appropriate, lol

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Problem with Call command?

    It can be done, and the code you posted would do it. I personally think that a change event is exactly that and should only be triggered by changing that control. If you have code that should run in response to a control's change and also under other circumstances, I think it should be in a separate routine and called from both places.

  5. #5
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: Problem with Call command?

    Ok, thanks mate. I'll explore your advice, ?Thanks

  6. #6
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: Problem with Call command?

    All fixed, thanks for your guidance :-)

+ 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. Form Command Add In in Excel 2010- How to call this command to run with VBA
    By BI Guy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-18-2014, 06:02 AM
  2. Master Command Button to call on other Command Buttons located in other Workbooks
    By MrNickRegan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2013, 07:57 PM
  3. Can run a command call a sub?
    By zhshqzyc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2011, 11:07 AM
  4. Adding a Call command to an existing VBA
    By PY_ in forum Excel General
    Replies: 4
    Last Post: 09-14-2010, 02:16 PM
  5. Command Button Call-up
    By LAWDAWG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2009, 09:55 PM
  6. Call Action From A Command Bar
    By joe12613 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2007, 11:26 AM
  7. Can VBA call a DOS command?
    By Ai_Jun_Zhang in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2007, 07:20 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