+ Reply to Thread
Results 1 to 4 of 4

VBA Copy/Paste Data Based Off ActiveX Dropdown Box

  1. #1
    Registered User
    Join Date
    06-11-2014
    Posts
    10

    VBA Copy/Paste Data Based Off ActiveX Dropdown Box

    Hi,

    I am trying to get my idea to work but I have tried several recommendations off various forums with no luck. Hopefully someone can give me a helping hand here.

    What I am trying to do is copy data from "Fluids" and paste it to "Plots" based off dropdown box selection. I have used Listfillrange to populate the dropdown box based off data in "Fluids".

    My goal here is to copy the data From "Fluids" cells B3,C3,D3 paste to "Plots" F10,G10,H10 / "Fluids" cells E3,F3 paste to "Plots" E13,F13 if user selected 'Spectro Ultra Light' from dropdown box.

    I am attaching the sheet here so you can actually see what I am trying to do.

    Thanks in advance for any assistance anyone might be able to offer.

    Terry
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: VBA Copy/Paste Data Based Off ActiveX Dropdown Box

    Hi welcome to the forum
    I don't know where you were looking...
    There are many ways to do this but this is the way (quick-and-dirty) that I'd do it.
    Attached Files Attached Files
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    06-11-2014
    Posts
    10

    Re: VBA Copy/Paste Data Based Off ActiveX Dropdown Box

    I have been looking all over the web and I found so many different vba codes that I just had sensory overload. I appreciate the time you took coding this and as I am looking at it things are starting to make sense as to how it all works.

    Thanks Again!!

    Terry

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: VBA Copy/Paste Data Based Off ActiveX Dropdown Box

    Hi Terry,
    I'm not the best one for adding comments to my code, this just came up and I typed it in.
    If you require some extra info, just holler.
    It's almost midnight here, I'm going off-line but just post and I will gladly help help you.

+ 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. ActiveX Combo Box and VBA code not working on multiple Data Validation Dropdown Lists
    By ringonohitorigoto in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2016, 04:05 PM
  2. Replies: 11
    Last Post: 05-23-2016, 07:06 PM
  3. Copy and Paste Entire Row Based on DropDown Selecton
    By manisha.williams in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-24-2016, 11:51 AM
  4. [SOLVED] Copy and paste rows to new sheet based on dropdown value
    By j.farr3ll in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 03-31-2014, 06:16 AM
  5. [SOLVED] Autocomplete dropdown list, NOT data validation or ActiveX
    By Phillips Contracting in forum Excel General
    Replies: 7
    Last Post: 03-24-2014, 02:31 PM
  6. Dynamic Dependent ActiveX Dropdown from Column Data
    By mani_bbc05 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2013, 02:17 PM
  7. Copy and Paste to Worksheet using Combobox (ActiveX)
    By okriskao in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-23-2009, 09:23 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