Userform question

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,743
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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
3,223
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,743
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,743
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,223
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,223
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,223
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,743
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,223
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,095,816
Messages
5,446,664
Members
405,413
Latest member
AlainCar

This Week's Hot Topics

Top