Result in list box depending on condition

jimpatel1993 · Post by **jimpatel1993** » 24 Sep 2021, 10:46

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

Post by **HansV** » 24 Sep 2021, 12:15

I don't understand Example 3. What do you mean by "Because there is no james and ryan for name Rohit(ZS22)"?

jimpatel1993 · Post by **jimpatel1993** » 24 Sep 2021, 17:11

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

Post by **HansV** » 24 Sep 2021, 19:02

Huh?

S0781.png

jimpatel1993 · Post by **jimpatel1993** » 24 Sep 2021, 19:49

Sorry hans
I think that's is wrong excel may be. I have attached the updated now.
Really sorry for this trouble.

Post by **HansV** » 24 Sep 2021, 19:50

Yes, that's different. I'll get back to you.

jimpatel1993 · Post by **jimpatel1993** » 24 Sep 2021, 20:10

Really sorry about that
Thanks a lot Hans

Post by **HansV** » 25 Sep 2021, 11:26

See the attached version. I added Rajor (400) to the source list of listbox1 (you had James twice).

Conditions (1).xlsm

jimpatel1993 · Post by **jimpatel1993** » 25 Sep 2021, 18:18

Fantastic Hans
Thanks a lot for your time and effort
Really appreciated

jimpatel1993 · Post by **jimpatel1993** » 27 Sep 2021, 08:45

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

Post by **HansV** » 27 Sep 2021, 08:54

Sorry, can you explain in more detail what you want?

jimpatel1993 · Post by **jimpatel1993** » 27 Sep 2021, 09:21

Sure
I have attached 2 example query.

Thanks a lot Hans

Post by **HansV** » 27 Sep 2021, 09:27

Would it be OK to use a text box instead of a list box?

Post by **HansV** » 27 Sep 2021, 09:30

Or even better, three separate text boxes?

jimpatel1993 · Post by **jimpatel1993** » 27 Sep 2021, 09:33

That will be perfect I guess
Thanks Hans

Post by **HansV** » 27 Sep 2021, 09:59

See the attached version.

Conditions (1).xlsm

jimpatel1993 · Post by **jimpatel1993** » 27 Sep 2021, 10:16

That's great
Fantastic
Thanks a lot for your effort Hans
Much appreciated

jimpatel1993 · Post by **jimpatel1993** » 28 Sep 2021, 15:23

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.

Post by **HansV** » 28 Sep 2021, 18:55

Here it is with the added code.

Conditions (1).xlsm

jimpatel1993 · Post by **jimpatel1993** » 29 Sep 2021, 07:16

Great
Thanks a lot for your kind help

Eileen's Lounge

Result in list box depending on condition

Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition

Re: Result in list box depending on condition