Consulting

Results 1 to 8 of 8

Thread: Cant get VBA Code to work. Would appreciate help.

  1. #1
    VBAX Newbie
    Joined
    Jun 2020
    Posts
    3
    Location

    Question Cant get VBA Code to work. Would appreciate help.

    Hello,

    I am a novice Excel/VBA user. I am trying to create an Excel worksheet for my job and I am stuck on the last Command Button. I will attach pictures of what I am trying to do and my "non-functioning" code.

    What I am trying to do is enter a key name in D7 and the quantity issued in F7. When the "update inventory" Command Button is clicked i would like the inventory to automatically be adjusted on the "Key Inventory" sheet.

    Any help would be greatly appreciated!

    issue.jpg
    COMMAND BUTTON.jpg

  2. #2
    You need to attach an example of the workbook. Pictures aren't much help.
    Hope that helps.
    Get the free Excel based Toolbar or click here for free examples & Excel Consultancy

    RoyUK

  3. #3
    You need to attach an example of the workbook. Pictures aren't much help.
    Hope that helps.
    Get the free Excel based Toolbar or click here for free examples & Excel Consultancy

    RoyUK

  4. #4
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,635
    In a worksheet you don't even need a button if calculation is automatic.

  5. #5
    VBAX Newbie
    Joined
    Jun 2020
    Posts
    3
    Location
    Quote Originally Posted by snb View Post
    In a worksheet you don't even need a button if calculation is automatic.
    If there is an easier way then I am all ears, Sir!!

    Thank you!

  6. #6
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,635
    Your picture doesn't work at all.

  7. #7
    VBAX Newbie
    Joined
    Jun 2020
    Posts
    3
    Location
    I am not having much luck! Can I drag a copy of the workbook over to the forum?

    I am not sure how to link the workbook to in here. I assume any link I post will go bad since the workbook is inside the Company network. Any other suggestions?

    Thanks for your time so far, sorry I am clueless to all this.

  8. #8
    You don't link it you attach a copy like you did the pictures. Remove any sensitive data first
    Hope that helps.
    Get the free Excel based Toolbar or click here for free examples & Excel Consultancy

    RoyUK

Posting Permissions

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