+ Reply to Thread
Results 1 to 3 of 3

Sending data to another workbook with command button

  1. #1
    Registered User
    Join Date
    11-19-2019
    Location
    Israel
    MS-Off Ver
    2013
    Posts
    12

    Sending data to another workbook with command button

    Hello, im trying to send a value of a list box from one workbook to a cell in another workbook and nothing that i can think of seems to work.

    At first, i took a random cell in the workbook that contains the list box and gave it the list box value by using Index function with this Office support formula:

    Tip: You can use the INDEX function to show an item name instead of a number. In our example, the combo box is linked to cell B1 and the cell range for the list is A1:A2. If the following formula, is typed into cell
    Please Login or Register  to view this content.
    , when we select the item "Sorbet" is displayed in C1.


    Then, ive tried to copy that random cell that contains the value of the list box that i wanted to transfer to an another workbook cell and i just couldnt make it.

    tried using this code

    Please Login or Register  to view this content.
    Massage i keep getting is subscript out of range and other things that wont work, help please!
    Last edited by davesexcel; 11-20-2019 at 08:22 AM. Reason: Please do not delete the original question

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,606

    Re: Sending data to another workbook with command button

    Try something like this. Change "Sheet1" to suit.

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    11-19-2019
    Location
    Israel
    MS-Off Ver
    2013
    Posts
    12

    Re: Sending data to another workbook with command button

    omg thank you very much! worked!

+ 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. Save data from one workbook to another by pressing a command button
    By SpeckM in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2015, 10:22 AM
  2. [SOLVED] Paste data from one worksheet to another workbook using command button
    By 4lysaabri in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-12-2014, 01:55 PM
  3. Command button to send data to another workbook
    By alfgrey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2014, 03:28 AM
  4. [SOLVED] command button to move data to new sheet in workbook
    By tjdarla in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-14-2013, 06:28 PM
  5. Replies: 0
    Last Post: 07-24-2013, 01:09 PM
  6. [SOLVED] Command Button in one workbook and data to be executed in another workbook
    By aswin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2012, 06:02 AM

Tags for this Thread

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