+ Reply to Thread
Results 1 to 6 of 6

Selected data to be displayed in userform textbox

  1. #1
    Registered User
    Join Date
    06-20-2015
    Location
    singapore
    MS-Off Ver
    2013
    Posts
    13

    Selected data to be displayed in userform textbox

    Hi Gurus, need some advises.

    2 tasks I wish to achieve.

    1. Would like to have the headers (Loc, Type, Stats) displayed in the textbox
    2. Set the column width within the textbox.

    Attached is a sample file.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-20-2015
    Location
    singapore
    MS-Off Ver
    2013
    Posts
    13

    Re: Selected data to be displayed in userform textbox

    Anyone can help?

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Selected data to be displayed in userform textbox

    Can you give more details please:
    1. Would like to have the headers (Loc, Type, Stats) displayed in the textbox
    => Can you show in display exactly where to put it

    2. Set the column width within the textbox.
    => Can you show an example of the final result and the column width you want
    - Battle without fear gives no glory - Just try

  4. #4
    Registered User
    Join Date
    06-20-2015
    Location
    singapore
    MS-Off Ver
    2013
    Posts
    13

    Re: Selected data to be displayed in userform textbox

    Quote Originally Posted by PCI View Post
    Can you give more details please:
    1. Would like to have the headers (Loc, Type, Stats) displayed in the textbox
    => Can you show in display exactly where to put it

    Something like this.
    lvw_headers1.jpg or
    lvw_noheaders1.jpg

    2. Set the column width within the textbox.
    => Can you show an example of the final result and the column width you want
    I have not finalized on the column with. But possible to change in the code in the future?


    Thanks
    Last edited by cklee; 07-12-2015 at 09:32 AM.

  5. #5
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Selected data to be displayed in userform textbox

    But this is not what is displayed today: Loc, Type, Stats

  6. #6
    Registered User
    Join Date
    06-20-2015
    Location
    singapore
    MS-Off Ver
    2013
    Posts
    13

    Re: Selected data to be displayed in userform textbox

    Quote Originally Posted by PCI View Post
    But this is not what is displayed today: Loc, Type, Stats

    The image is just for reference.
    I want to show where the headers will be. Not critical, as long as headers/ labels with reference to the search result for easy interpretation.

+ 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. Replies: 4
    Last Post: 01-29-2014, 05:53 AM
  2. UserForm: Enable Textbox When "Other" Selected in MultiSelect Listbox (Excel 2010)
    By excelforumkeys in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-02-2014, 06:40 PM
  3. [SOLVED] Pass Value of combobox selected in Userform as input to textbox of other userform
    By Pradeepg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2013, 10:32 AM
  4. Sum Value Displayed on userform textbox
    By mrswamy2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-26-2013, 02:22 PM
  5. Display a UserForm based on Data selected in another UserForm's ListBox
    By RPhilbin83 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-26-2011, 11:35 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