+ Reply to Thread
Results 1 to 3 of 3

ListBox Rows and SendKeys function

  1. #1
    Registered User
    Join Date
    03-20-2020
    Location
    Portugal
    MS-Off Ver
    18.2002.1101.0
    Posts
    5

    ListBox Rows and SendKeys function

    Hello,

    I'm having trouble adding more than one entry in my ListBox. I'm incrementing the i, but it ain't working.
    Also, I would like that after clicking the ADD button or clicking the Enter key, it would have the same effect.
    Here's the code i have

    Please Login or Register  to view this content.
    Best regards

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,302

    Re: ListBox Rows and SendKeys function

    Declare your variables before the Sub
    They are losing their value when the Sub ends.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-20-2020
    Location
    Portugal
    MS-Off Ver
    18.2002.1101.0
    Posts
    5

    Re: ListBox Rows and SendKeys function

    Thank you for the response

+ 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. [SOLVED] List consecutive hidden rows as range of rows vs single rows, in a listbox
    By guyglk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-04-2020, 06:10 PM
  2. [SOLVED] VBA to search table for number and populate listbox with all rows with a total of the rows
    By rahul_ferns76 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-08-2019, 01:38 AM
  3. API Calls to replace SendKeys{TAB} function
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-09-2015, 09:50 AM
  4. Rows in Listbox to rows in Excel (Range)
    By Littlefarmer in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-17-2015, 05:50 AM
  5. Find the rows in excelsheet and pop up listbox with those rows
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-09-2010, 12:11 PM
  6. SendKeys function
    By moglione1 in forum Excel General
    Replies: 1
    Last Post: 11-07-2005, 11:00 AM
  7. [SOLVED] changing a SendKeys "(^+{home})" to a function
    By filo666 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-12-2005, 07:07 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