+ Reply to Thread
Results 1 to 2 of 2

Add a button to cell from Userform

  1. #1
    Forum Contributor
    Join Date
    12-05-2008
    Location
    Kiruna
    Posts
    163

    Add a button to cell from Userform

    Hi!

    Im have a userform with a listbox and a textbox and a commandbuttton

    When i click the command button it adds the values from the listbox and textbox to the first empty row, that works fine but also want to add a new button on every row i add.
    Something like this:

    Column A, B, C

    Listbox value, Textbox value, new button
    Listbox value, Textbox value, new button
    Listbox value, Textbox value, new button
    Listbox value, Textbox value, new button

    Etc

    I have tried this code but the add button line seems to be wrong:
    Please Login or Register  to view this content.
    The whole code i use is:
    Please Login or Register  to view this content.
    Can some one guide me in the right direction to add a button togheter with the values from the listbox and textbox ?

    Best regards

    Petter

  2. #2
    Forum Contributor
    Join Date
    05-16-2010
    Location
    glasgow scothland
    MS-Off Ver
    Excel 2007
    Posts
    112

    Re: Add a button to cell from Userform

    Hello Petter,

    I am no expert but i found this code online.
    Maybe you might be able to fit it into your needs.

    Please Login or Register  to view this content.

    It adds a button to 3rd column.

    Hope it helps.

+ 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] Userform code fails when the userform is called from a custom ribbon button
    By klonbeck in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2013, 03:00 PM
  2. [SOLVED] Userform submit button to load listbox1 and listbox2 selection to same cell
    By wishn4fishn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2013, 03:06 PM
  3. Userform Option Button to Show/Hide Another Option Button on same Userform
    By R_S_6 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2010, 09:44 AM
  4. Userform Button Caption based on cell Value
    By zerodegreec in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-09-2010, 01:55 AM
  5. [SOLVED] Looping procedure calls userform; how to exit loop (via userform button)?
    By KR in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-27-2005, 08:05 AM

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