+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 21 of 21

Combobox decides path of textbox value to particular cells in excel, Need VBA Code

  1. #16
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,028

    Re: Combobox decides path of textbox value to particular cells in excel, Need VBA Code

    Like this


    Kind regards
    Leo
    Attached Files Attached Files

  2. #17
    Registered User
    Join Date
    03-23-2015
    Location
    India
    MS-Off Ver
    MS Office 2007
    Posts
    16

    Re: Combobox decides path of textbox value to particular cells in excel, Need VBA Code

    Dear LeoTaxi,

    Thanks a lot for the answer, It came to senses that the headers also have more importance in relation to the code.

    Here i have added a column G in between the first six first identification column and the rest A1, A2, A3......... with title "Category" which contains the selected value of the Combobox1 (Example the name of the yarns "JackBrow" "Honeycom spun" etc all 11 Yarns) in the Category Column Before A1 Column.
    So that I can uses Vlookup function or If Function to sort out the Data into another sheet. The Category column will act as Lookup value, without which I wil be unable to sort out the data into other sheets.

    I am sorry to tell you this before.

    I have a lot to prepare which you can see in the Listsource sheet. (My Preparations), I am not even at the start of it. Lot to do......

    In UserForm1, the combox1 (selected value should go to Column G, row by row on each submission)

    Once again Lots of thanks for the quick answers. God bless you.

    Latest file attached "2018.SRVF" (title of file)

    Thanks,

    Regards,
    Mukhtar56
    Attached Files Attached Files

  3. #18
    Registered User
    Join Date
    03-23-2015
    Location
    India
    MS-Off Ver
    MS Office 2007
    Posts
    16

    Re: Combobox decides path of textbox value to particular cells in excel, Need VBA Code

    Dear LeoTaxi,

    Please check last letter on page 2,

    Regards,
    Mukhtar56

  4. #19
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,028

    Re: Combobox decides path of textbox value to particular cells in excel, Need VBA Code

    change this line
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Kind regards
    Leo

  5. #20
    Registered User
    Join Date
    03-23-2015
    Location
    India
    MS-Off Ver
    MS Office 2007
    Posts
    16

    Re: Combobox decides path of textbox value to particular cells in excel, Need VBA Code

    Dear LeoTaxi,

    You solved my Major problem, It might be very easy for you, but it was very tough for me because I do not know that subject VBA. I tried the whole day for the answers on the Internet but in vain. If you can see my last attachment uploaded yesterday especially the sheet "Listsource", There I have prepared a list of what I have to prepare to complete this Project. I am just at the start of it. I have lot to do yet.

    There are few people on earth who are kind souls who have the patience to help out others and you are one among them. God bless you a lot. I started learning computer from 2003 onwards and I a bit slow, but never give up hope. My age is 60. So I am a slow learner.

    There are lot of good books available on the Internet in PDF form especially on this site for free Can you please recommend me some good name of a book through which I can learn how to code in a better way VBA coding.

    Thank a lot, It worked fine. God bless you a lot.
    You are a kind person on this forum and I thank the forum owners too for such a nice forum.

    Regards,
    Mukhtar

  6. #21
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,028

    Re: Combobox decides path of textbox value to particular cells in excel, Need VBA Code

    No Mukhtar, can not help you with title of good book, i never readed 1 so difficul to say for me
    i learned all by practice, practice and practice on forums like this one


    Kind regards
    Leo

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

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