+ Reply to Thread
Results 1 to 2 of 2

Userform to display certain elements (variable)

  1. 02-24-2014, 09:00 AM #1
    nickmax1
    nickmax1 is offline
    Valued Forum Contributor
    Join Date
    08-10-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    721

    Userform to display certain elements (variable)

    I have a userform that uses 3 dropdowns and a freeform textbox to place into a cell.

    Please Login or Register  to view this content.
    Currenty the code above lists the 4 entries in one cell. What I would love it to do is have an if statement in there, to say that If ntulist.listindex = blank then 
    Please Login or Register  to view this content.
    If modellingstatus.listindex = blank then
    Please Login or Register  to view this content.
    if they are both blank then 
    Please Login or Register  to view this content.
    can anyone help?
    Reply With QuoteRegister To Reply
  2. 02-24-2014, 10:00 AM #2
    Izandol
    Izandol is offline
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Userform to display certain elements (variable)

    May you not simply use Trim:
    Please Login or Register  to view this content.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Run-time error '91' - Object variable or With block not set // getting HTML elements of we
    By Bootwalker in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2014, 11:33 AM
  2. Resources for Using VBA to Manipulate Silverlight Elements like HTML Elements
    By linear_db in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-16-2013, 04:43 PM
  3. Sorting array variable elements ascending
    By Gabor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2011, 04:34 AM
  4. How to best display mapped XML with nested repeating elements
    By theblang in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2010, 04:29 PM
  5. is it possible to draw a bar diagram with variable number of elements?
    By bagullo in forum Excel General
    Replies: 2
    Last Post: 10-09-2009, 07:17 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1