Results 1 to 5 of 5

Populating a userform based on a range of 3 columns

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-14-2007
    Location
    Chester, England
    MS-Off Ver
    2010 & 2016
    Posts
    312

    Populating a userform based on a range of 3 columns

    Hello All

    I have attached a spreadsheet to show what I am trying to achieve in terms of look and functionality but I am not 100% sure if text boxes would be the best way to do it.

    The number of rows would be dictated by values in column “A” (which can change). The intention is that the userform would populate the values available and the user could then populate the missing information on the userform. The “Code” would always be populated; there would never be a blank in Column A.

    If I have made any sense, I wonder if someone could point me in the right direction in terms of whether textboxes are the correct way to go and if not what I should be looking at.

    If text boxes are the best way to go, is it possible to add them to the userform based on the number of records in column A?

    Thanks in advance for any help or suggestions.

    Regards
    Jim
    Attached Files Attached Files
    Last edited by JimmyA; 03-02-2012 at 12:42 PM.

Thread Information

Users Browsing this Thread

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

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