Help with UserForm VBA

[MG3]

Hello,

I am in need of some help with userform VBA. If you choose to take on this task let me know what you need.

Thanks for your help with this,

Mark G

[bakerman2]

Don't have time for more right now but this will get you started.

The code populates the StartTime combo and filters the listbox when a value is chosen in that combo.

Please Login or Register  to view this content.

[MG3]

Thank you Sir! Works great.

[bakerman2]

This one should cover it all.

[MG3]

Thank you for your time. Works absolutely great but how do I get it to populate the large list bx with the name selected along with the device number selected before submitting the info to the worksheet?

How much do I owe you for your work on this?

[bakerman2]

Everthing works as per your instuctions sheet.

Select StartTime, select Name, enter Device# and click checkout-button.

You can enter 1 or more names and Device# per session.

To delete an entry from bottom Listbox, select it and click Delete.

The Edit-button isn't coded because that would require additional Textboxes and IMHO it's easier to delete a faulty entry and just create a new one from above Listbox.

On clicking Submit-button all entries are written to Sheet.

I've changed the layout from the bottom-Listbox to Landscape so you can see all info that's to be written to sheet.

How much do I owe you for your work on this?

This is a free forum but a click on the reputation star at the bottom left of one of my posts is always appreciated.

[MG3]

Sir I found a bug in your coding when I was running the model.

Attachment 665311

When I add more than 2 employees to the list bx then click submit it only adds 2 lines to the worksheet then I get the error msg.

Mark

[bakerman2]

New version.

1. Bug fixed
2. ListBox clears after submitting.
3. Edit button removed.
4. Search Employee button removed since Listbox autfilters with every character entered in TextBox.
5. MsgBox when no CheckIn # is found.
6. Checkin Clear button removed since clearing is automatic now.

Test it and let me know when if find new errors or want other improvements or changes.

[MG3]

Hello,

Management would like couple changes. First have the txtbx "txtbxHandHeldNumber" unload itself when the Check Out Handheld button is pressed and just have the clear list button unload the list bx. Also you should see two Option buttons added that when someone is adding a new employee to the Employee sheet, they can add their name and their status as well.

Thanks again for your time. MG3_HH2_rev3.2 file

MG

[bakerman2]

Fixed as per requirement.

[MG3]

Thank you so much

[bakerman2]

You're welcome and thanks for rep+.

[MG3]

I have one last request. I noticed the txt bx to check in the handhelds that it only accepts a 3 digit number. We have devices from 1 to 140. The txtbx to check out the devices works great.

Thanks

MG

[bakerman2]

Change the code from this sub

Please Login or Register  to view this content.

to this.

Please Login or Register  to view this content.

[MG3]

Works great thanks