Result in list box depending on condition
-
- 2StarLounger
- Posts: 153
- Joined: 31 Jan 2021, 09:12
Result in list box depending on condition
Hi
Thanks a lot again for looking at my post.
Really apologies as I need to attach my query in word document as I need to go thorough few examples.
Any help will be much appreciated and thanks again for this forum and kind people for help.
Jim
Thanks a lot again for looking at my post.
Really apologies as I need to attach my query in word document as I need to go thorough few examples.
Any help will be much appreciated and thanks again for this forum and kind people for help.
Jim
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78534
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Result in list box depending on condition
I don't understand Example 3. What do you mean by "Because there is no james and ryan for name Rohit(ZS22)"?
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 153
- Joined: 31 Jan 2021, 09:12
Re: Result in list box depending on condition
Thanks for your reply Hans
What I mean is if you filter excel sheet to name Rohit(ZS22) you won't find any James or Ryan under Rohit(ZS22)
Hope I made sense. Pls let me know if it is not clear. I will explain more about logic.
Thanks a lot Hans
What I mean is if you filter excel sheet to name Rohit(ZS22) you won't find any James or Ryan under Rohit(ZS22)
Hope I made sense. Pls let me know if it is not clear. I will explain more about logic.
Thanks a lot Hans
-
- Administrator
- Posts: 78534
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Result in list box depending on condition
Huh?
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 153
- Joined: 31 Jan 2021, 09:12
Re: Result in list box depending on condition
Sorry hans
I think that's is wrong excel may be. I have attached the updated now.
Really sorry for this trouble.
I think that's is wrong excel may be. I have attached the updated now.
Really sorry for this trouble.
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78534
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Result in list box depending on condition
Yes, that's different. I'll get back to you.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 153
- Joined: 31 Jan 2021, 09:12
Re: Result in list box depending on condition
Really sorry about that
Thanks a lot Hans
Thanks a lot Hans
-
- Administrator
- Posts: 78534
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Result in list box depending on condition
See the attached version. I added Rajor (400) to the source list of listbox1 (you had James twice).
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 153
- Joined: 31 Jan 2021, 09:12
Re: Result in list box depending on condition
Fantastic Hans
Thanks a lot for your time and effort
Really appreciated
Thanks a lot for your time and effort
Really appreciated
-
- 2StarLounger
- Posts: 153
- Joined: 31 Jan 2021, 09:12
Re: Result in list box depending on condition
Hans
Really fantastic work. Thanks a lot.
Just one question. Do you know how to give space between each result?
That is Andy, James and Ryan results are coming together in Andy row. Any idea pls?
Thanks again
Really fantastic work. Thanks a lot.
Just one question. Do you know how to give space between each result?
That is Andy, James and Ryan results are coming together in Andy row. Any idea pls?
Thanks again
-
- Administrator
- Posts: 78534
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Result in list box depending on condition
Sorry, can you explain in more detail what you want?
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 153
- Joined: 31 Jan 2021, 09:12
Re: Result in list box depending on condition
Sure
I have attached 2 example query.
Thanks a lot Hans
I have attached 2 example query.
Thanks a lot Hans
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78534
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Result in list box depending on condition
Would it be OK to use a text box instead of a list box?
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 78534
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Result in list box depending on condition
Or even better, three separate text boxes?
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 153
- Joined: 31 Jan 2021, 09:12
Re: Result in list box depending on condition
That will be perfect I guess
Thanks Hans
Thanks Hans
-
- Administrator
- Posts: 78534
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Result in list box depending on condition
See the attached version.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 153
- Joined: 31 Jan 2021, 09:12
Re: Result in list box depending on condition
That's great
Fantastic
Thanks a lot for your effort Hans
Much appreciated
Fantastic
Thanks a lot for your effort Hans
Much appreciated
-
- 2StarLounger
- Posts: 153
- Joined: 31 Jan 2021, 09:12
Re: Result in list box depending on condition
Hi Hans
Sorry to ask you one more question
Is it possible to show only filtered items in time sheet.
That is
Example
When user select Andy(v110) and Rajor (400)
The time sheet will show only those two related names and rest will be hidden.
Example 2
When user select Rohit(ZS22) James (B200K) And Andy (v100) then sheet named as time will auto filter to those 3 names only.
Any possibility please and really sorry for this question.
Sorry to ask you one more question
Is it possible to show only filtered items in time sheet.
That is
Example
When user select Andy(v110) and Rajor (400)
The time sheet will show only those two related names and rest will be hidden.
Example 2
When user select Rohit(ZS22) James (B200K) And Andy (v100) then sheet named as time will auto filter to those 3 names only.
Any possibility please and really sorry for this question.
-
- Administrator
- Posts: 78534
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Result in list box depending on condition
Here it is with the added code.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 153
- Joined: 31 Jan 2021, 09:12
Re: Result in list box depending on condition
Great
Thanks a lot for your kind help
Thanks a lot for your kind help