Dear All,
I am new at this. I am trying to import my list box data at my specific Sheet but failed to do so. If any one can help me out it will be a great help.
Dear All,
I am new at this. I am trying to import my list box data at my specific Sheet but failed to do so. If any one can help me out it will be a great help.
You've used DatePicker controls which can cause problems because they are not always available on every computer. use an alternative, some examples here.
What are you trying to do, import data from the sheet to the userform?
Your data sheet is not optmised for data or ListBoxes. Data should be stored in a Table Format with only one header row and no complete empty rows or columns
Roy,
My user form is populate shows the correct data and it's working fine.
I am trying to import my Listbox5 data to on (Adata Sheet) on transpose basis. For each employee I need the date and the A or P data which is populate on Listbox5.
Just like this one...
But my issue is the date and am able to set it for only one range (D1). What I want is when ever i am saving the data it should found the next blank column and add.
Please find this one for example....
Your datepickers will be problematic if you intend this to be used on different computers.
For DTPicker1 I will go through as per your recommendation on your web site. But please help me out to insert the data in from list box 5 to next blank column..
I don't understand what you are trying to do.
I can see D1 has a date.
The ListBoxes populate with existing data(though not efficiently). What do you want to save to the sheet in the next empty column?
The data in ListBox 5 must already exist on the sheet
In the Save code lTransferRow has no value so it will always be 1.
Not sure how you can fix this except by locating the employee's name using .Find. As I said, poorly formatted data makes things more difficult
Don’t have an account yet? Register yourself now and be a part of our community!