VBA to extract userform information to a worksheets

Hai Again,

Required help to export data from listbox, Combobox & 2 textboxes from userform to worksheet.

User search a provider which is available on Data worksheet and unique items listed in listbox.
User have to select that item and from dropdown.
User have to enter start date and end date.

Header D information automatically copies based on Header E which is selected on listbox.
The other information which user entered or select from above controls will be send to worksheet.

Copy of expecting result is attached for your reference.

Hi,

See the modified copy of your Sample Workbook which contains the following modifed code in the UserForm code module:
a. ItmDescSearch_Click() - modified the code to include the 'Provider Code' in the ListBox as a hidden item.
b. CommandButton5_Click() - Added code to implement 'Export'.

Please Login or Register  to view this content.

To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. Dim i as Integer). https://www.excel-easy.com/vba/examp...-explicit.html

Lewis

Thanks Lewis for response to my request.

I cannot post any comments on this site since 2days.

Whoever it is working through my mobile.

Can we add a validation if a user skip or did not fill any fields the a message will be populated saying that (Field name) cannot be felt blank.

Your welcome.

I think I fulfilled your request with the following major changes:
a. I modified the UserForm slightly to add a 'Status' Label.
b. I disabled the 'X' at the top right of the UserForm.
c. I modified CommandButton5_Click() in the UserForm module to check the values in the UserForm.
d. Major Modification to ordinary code module 'ModProviderSearchUserForm' was 'Module1'.

NOTE: You have to set Columns 'D' and 'E' on the Spreadsheet Output sheet to the proper Date Format you want displayed.


See the attached file which contains the following excerpted modifed code.

In the UserForm code module:

Please Login or Register  to view this content.

In Ordinary Code Module ModProviderSearchUserForm:

Please Login or Register  to view this content.

Lewis

Thanks Lewise.

It is working as per my requirement.