Results 1 to 4 of 4

Insert a number into specific cell depending on selected label

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-04-2008
    Location
    West Calder, Scotland
    MS-Off Ver
    365
    Posts
    430

    Insert a number into specific cell depending on selected label

    Good afternoon folk

    I have a Userform with 10 labels,,,, is there a way when a label is selected the relevant number is inserted into cell A2 in worksheet 2

    e.g,,, if the third label is selected,, the number 3 is inserted

    if the 8th label is selected the number 8 is inserted

    etc



    many thanks

    JT
    Last edited by JamesT1; 07-12-2016 at 05:27 AM. Reason: update requested information

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] excel userform to show emails on selected subject from listbox
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2015, 02:46 PM
  2. [SOLVED] UserForm Change of data value event- Label show or hide
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2014, 11:54 AM
  3. [SOLVED] Listbox selected row to show on label caption
    By monkey1184 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-22-2013, 08:09 PM
  4. UserForm label to show current date
    By Tomtril in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-13-2013, 06:57 AM
  5. [SOLVED] Userform to show date format in textbox or label
    By coach.32 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-17-2013, 08:55 PM
  6. [SOLVED] Show label in UserForm
    By jdasp49 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-16-2013, 09:30 AM
  7. Show data from a selected row in an excel userform
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 08-20-2012, 03:17 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