UserForm Search Using Two Data Search Criteria and Export the Receipt

[Chimpanzo1988]

Hello folks And I created a database of monthly payments from the workers of certain transport organization. The spreadsheet contains two ComboBox:

The first one called cboLocation (text lable = Name) - where the list of employee names is located

The second named CmBoxMeses (text lable = Period) - where the respective months of payment are located.


If I select a name in the combobox cboLocation (text lable = Name) and click the Search button it fetches me data only for the month of May. and if the same employee is paid the following month (June)?

In this case what I intend is:

1 --- select the Name (in the combobox cboLocation) and the Specific Payment Period (in the combobox CmBoxMeses)

So he searches me for the data for that month. and If only sellect the name in the combobox cboLocation it should give an alert saying that "Selects the Period Desired"

2 --- Use the Receipt Button on the UserForm so that when clicked it exports the searched data to the "Receipt" sheet (filling it out of the box and creates a pdf that can be delivered to the employee.

Here's the spreadsheet link

https://drive.google.com/open?id=1I7jhF

... Ejz_5_nxve

Thank you

Anilton Chimpanzo

 

[SkipVought]

Hi,

Welcome to Tek-Tips.

Is there a question? I didn't see one.

I certainly have a few.

Where is the "Receipt" sheet?

Why would you have a list of First-of-the-Month dates that will need to be maintained and is unnecessarily long. Why not simply a list of Months, to which you can calculate the first-of date for the appropriate year.

Why would you pre-load formulas in unused rows? Pre loading data unto unused rows, creates unexpected problems. If you were to use the Structured Table feature, those formulas will propagate to new rows as they are added to the table.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[SkipVought]

You also have 10 modules, most of which have one procedure.

Module1 contains procedures for sheets that do not exist in your workbook.

Your organization is confusing and counterproductive.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[Chimpanzo1988]

Dear Gents
Sorry for the mistakes, I am not too good.
But see the new sheet on this link:

https://drive.google.com/open?id=1GwH7ekNFk1LjmX6ueNVBGBFrVd7BqTNF

Regards
Chimpanzo

 

[SkipVought]

I'm close to posting a solution, but I have a question regarding the Period value that you want on the Receipt. I'd assume that you want the latest Period value. Or do you want to pick from a list of Periods for the selected Nome?

My solution will not have a UserForm. Rather it employs your Receipt as the form by using an in-cell drop-down list to select a Nome and possibly the Periodo also.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[SkipVought]

Well here's a version to check out.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[SkipVought]

???

Simao Jorge has 2 Jun rows, whereas all others have one row per period. That causes problems unless there is something I don't understand.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein