Page 3 of 5 FirstFirst 12345 LastLast
Results 21 to 30 of 43

Thread: Userform question
Thanks Thanks: 0 Likes Likes: 0

  1. #21
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,379
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    10 Thread(s)

    Default Re: Userform question if I may ask please

    OK. has a nice evening. Check back in tomorrow and let me know how things worked out.
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please I知 not perfect yet. "Memories are forever"

  2. #22
    Board Regular
    Join Date
    Nov 2010
    Posts
    2,061
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Userform question if I may ask please

    Quickly looking at the supplied code where about is the part which shows the visits ?

    I had in mind say select customer John Smith and I would see s list of visits I had made to him ?
    Not seeing this laid out I can稚 quite see how it works until tomorrow

  3. #23
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,379
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    10 Thread(s)

    Default Re: Userform question if I may ask please

    You told me this:
    My worksheet is like so.
    Column B is customers name.
    Column D is where advert was seen.
    Column F is telephone number
    Column H is post code
    Column J is Area
    Column L is Price paid
    Column N is last cut
    Column P is Miles
    Column R is Address
    Column T is Next Cut Due

    I see nothing here about visits
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please I知 not perfect yet. "Memories are forever"

  4. #24
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,379
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    10 Thread(s)

    Default Re: Userform question if I may ask please

    I like helping you and I do see you have asked numerous questions in several other posting on this forum on the same subject matter.

    Like show my visits is hard to do when I see nothing here about where the visits are.

    If you did not write the code you showed and found it some place and you do not understand it I can see how trying to modify it may be very hard for you.

    I hope you do not start another new posting and hope for better answers.

    It's just that specific details are always needed.
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please I知 not perfect yet. "Memories are forever"

  5. #25
    Board Regular
    Join Date
    Nov 2010
    Posts
    2,061
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Userform question if I may ask please

    Please show me a post where i have asked about the same subject.

  6. #26
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,379
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    10 Thread(s)

    Default Re: Userform question if I may ask please

    Very similar:
    https://www.mrexcel.com/forum/excel-...or-please.html

    Quote Originally Posted by ipbr21054 View Post
    Please show me a post where i have asked about the same subject.
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please I知 not perfect yet. "Memories are forever"

  7. #27
    Board Regular
    Join Date
    Nov 2010
    Posts
    2,061
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Userform question if I may ask please

    That was a month ago.
    This post has nothing to do with that but I don稚 even see why it has been dragged up & mentioned

  8. #28
    Board Regular
    Join Date
    Nov 2010
    Posts
    2,061
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Userform question if I may ask please

    Post #18 has now been applied and works well.

    Now i would like to see the multiple visits of say the same customer some how.
    Say the customer is John Smith and i have been to him 01/03/2019 01/04/2019 01/05/219 etc etc.
    What do i need to advise you & how will it then look etc on my form ?

    Thanks
    I have learning difficulties so please be patient if i'm slow on the uptake,Thanks Very Much...

  9. #29
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,379
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    10 Thread(s)

    Default Re: Userform question if I may ask please

    I thought I asked the question before but maybe you did not understand.

    So where on your sheet will I find this information:
    01/03/2019 01/04/2019

    I assume it will be on the same Row with The customer name but starting in What column?
    Will service dates start in column X or column Z or where?

    Unless I just skipped over seeing it I have never seen where this starts.

    It should start in the same column for each customer

    So if we find The name George in column B then to find service dates we would start looking across that row starting in column X for the service dates.

    But I need to know what column The service dates start in




    Like all service dates start in column X

    So the script would start looking in column X till the last column with data on that row.


    Like where will I find 01/03/2019

    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please I知 not perfect yet. "Memories are forever"

  10. #30
    Board Regular
    Join Date
    Nov 2010
    Posts
    2,061
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Userform question if I may ask please

    Hi,

    So in this example JEFF name is in B9 his dates that ive visited so far are in T9, U9, V9, W9 & then further visits will be entered into X9, Y9, Z9, AA9, AB9 etc etc
    This then also applies to the next customer so there dates will be entered in T10, U10, V10, W10 ETC TEC
    I have learning difficulties so please be patient if i'm slow on the uptake,Thanks Very Much...

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •