Results 1 to 20 of 20

populate a sheet through a userform

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-27-2021
    Location
    italy
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    109

    populate a sheet through a userform

    Hi I need a hand in finishing this userform, we accept suggestions on how to proceed, I need you to fill in the yellow cells, also if it is possible to do so, I would like to insert a condition that if you use the SELEZIONA ALIMENTO combox you will not can use the RICERCA ALIMENTO and vice versa.
    Finally I would like to use the command botton to insert the foods in the respective cell both when using the search and when selecting the food through the comboboxes

    To launch the userform just double click on a part of the sheet and it appears
    the userform is composed of a tetxtbox with text search + list box connected to the food database sheet, where the list box is connected to cell f12, again in this userform there are two other comboxes which allow me to recall the categories and the subcategories and using the commandbutton values ​​are entered in cell f11



    ps I think that to do this I use a ListFillRange in reverse or a for each loop
    Attached Files Attached Files
    Last edited by GrabberHackman; 06-12-2021 at 06:09 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] common userform for sheet 1 and sheet 2 but need data to populate from a different row
    By dav2020 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-20-2019, 08:33 PM
  2. [SOLVED] Basic Userform to populate sheet not working
    By Betsy Simpkins in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-09-2018, 02:55 PM
  3. Populate Excel Userform with Sheet names with double click to open the sheet ??
    By Shacker in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-08-2013, 03:54 PM
  4. Populate Excel Userform with Sheet names
    By PC in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-08-2013, 09:37 AM
  5. Populate a UserForm field with value from excel sheet
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-07-2012, 04:54 AM
  6. populate userform combobox with sheet names
    By tapapad in forum Excel General
    Replies: 3
    Last Post: 11-14-2008, 03:10 AM
  7. Populate sheet from userform
    By cityfc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2006, 06:25 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