Userform question

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,762
Office Version
2013
Platform
Windows
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.
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
3,380
Office Version
2007
Platform
Windows
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’t quite see how it works until tomorrow
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,762
Office Version
2013
Platform
Windows
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
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,762
Office Version
2013
Platform
Windows
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.
 

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
3,380
Office Version
2007
Platform
Windows
Re: Userform question if I may ask please

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

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
3,380
Office Version
2007
Platform
Windows
Re: Userform question if I may ask please

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

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
3,380
Office Version
2007
Platform
Windows
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
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,762
Office Version
2013
Platform
Windows
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

 

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
3,380
Office Version
2007
Platform
Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,102,630
Messages
5,488,004
Members
407,617
Latest member
Samanthad2007

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top