+ Reply to Thread
Results 1 to 3 of 3

Add data via userform to specific cells

  1. #1
    Registered User
    Join Date
    07-08-2015
    Location
    Canada
    MS-Off Ver
    10
    Posts
    6

    Add data via userform to specific cells

    Hello,

    I am having trouble figuring out a code to add data to specific cells. Ultimately, I want to add data to a cell and then have it go down to the next cell and so on. Here is a snap shot of what I want to happen.

    Selection
    Capture3.PNG
    cells
    Capture4.PNG

    *the number list is ComboBox5 and the Add button is Private Sub Add1_Click(). My range is ("month") which is Sheet12!$P$17:$P$28

    The whole function is supposed to act as an advanced filter search. But I want the range I enter data in to be dynamic and so, I want to be able to add to the list.

    hope that makes sense!

    thank you very much in advance!
    Last edited by gerardgerard; 08-13-2015 at 10:58 PM.

  2. #2
    Registered User
    Join Date
    06-03-2015
    Location
    Houston, Tx
    MS-Off Ver
    2010
    Posts
    64

    Re: Add data via userform to specific cells

    Can you post a copy of your spreadsheet?

    I use the following for one of my userforms, but the cell is fixed:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-08-2015
    Location
    Canada
    MS-Off Ver
    10
    Posts
    6

    Re: Add data via userform to specific cells

    Hey Jonathan,

    thanks for your reply.

    that is the start to my equation. The next part I am looking for is to add to the next cell if cell P17 contains a value.
    If P17 = 5 then
    insert next value in P18
    if P18 contains a value then
    insert next value in P19 and so on

    Thanks!

+ 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] Macro to copy specific data from one WB to specific cells in another WB based on specific
    By d_rose in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2014, 11:05 AM
  2. Enter Data from userform into cells starting from specific cell
    By jtemp57 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2014, 04:26 PM
  3. VB Userform - Populating Specific Cells
    By Arual28 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2013, 11:34 AM
  4. [SOLVED] Input Userform Data into Specific Cells & Loop?
    By shiftyspina in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2013, 07:00 AM
  5. [SOLVED] listbox on userform not showing specific cells
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2013, 12:29 PM
  6. Copy data from userform to specific cells in excel workbook
    By mimet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2013, 05:44 PM
  7. Transfer specific data on specific worksheet using userform
    By kriscar_44 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2010, 04:03 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