Billa7
asked on
Display Data in Userform
Hi Experts,
I need Experts help display data from Listing sheet (Column A and Column B) in userform at Data sheet when click “Userform” button at Data sheet. User should able to select the cell at Data sheet while the Userform still open. Hope Experts could help. Attached the workbook.
UserForm.xls
I need Experts help display data from Listing sheet (Column A and Column B) in userform at Data sheet when click “Userform” button at Data sheet. User should able to select the cell at Data sheet while the Userform still open. Hope Experts could help. Attached the workbook.
UserForm.xls
ASKER
Hi gowflow,
Actually Cartillo (his actual name is Theva) has introduced me EE, we were working together (same industry). In fact, one of the Experts also asking me the same question. I need to modify his workbook to adapt with my work process.
Apology for the confusion arise. What I need is to display Column A and B in Userform (yet to develop), need your help to create this.
The purpose of this Userform is to allow user select the data from this userform (Column A) and copied to the selected cell at "Data sheet". The copy should take place at Column C and D (duration) at Data sheet.
Actually Cartillo (his actual name is Theva) has introduced me EE, we were working together (same industry). In fact, one of the Experts also asking me the same question. I need to modify his workbook to adapt with my work process.
Apology for the confusion arise. What I need is to display Column A and B in Userform (yet to develop), need your help to create this.
The purpose of this Userform is to allow user select the data from this userform (Column A) and copied to the selected cell at "Data sheet". The copy should take place at Column C and D (duration) at Data sheet.
So let me recap then
You want a userform that will show all of Col A and B say in a listbox and when you click on a line say Type40 0:30 then you would have a button on that form that is called Transfer and you would select the cell in Data sheet where you want to paste this selected line and by activating on transfer it would copy both values from the listbox to the Data sheet Is that correct ?
If above assumption is correct then
1) What do you want to happen with the data originally copied like A nd B in the listbox do they need to be removed so it is not duplicated again ?
2) What if someone click on a wrong row as you already have data in sheet Data in col C and D or this is only an examle ?? I need clarification on this also
Pls advise
gowflow
You want a userform that will show all of Col A and B say in a listbox and when you click on a line say Type40 0:30 then you would have a button on that form that is called Transfer and you would select the cell in Data sheet where you want to paste this selected line and by activating on transfer it would copy both values from the listbox to the Data sheet Is that correct ?
If above assumption is correct then
1) What do you want to happen with the data originally copied like A nd B in the listbox do they need to be removed so it is not duplicated again ?
2) What if someone click on a wrong row as you already have data in sheet Data in col C and D or this is only an examle ?? I need clarification on this also
Pls advise
gowflow
ASKER
Hi gowflow,
You're absolutely correct.
1) What do you want to happen with the data originally copied like A nd B in the listbox do they need to be removed so it is not duplicated again ?
- No need, sometime I need to use the same title
2) What if someone click on a wrong row as you already have data in sheet Data in col C and D or this is only an examle ?? I need clarification on this also
- Sometime I do need to replace the existing title, if user intent to replace it, let it be.
I always add-in data at Listing sheet (column A and B), the userform should reflect accordingly.
You're absolutely correct.
1) What do you want to happen with the data originally copied like A nd B in the listbox do they need to be removed so it is not duplicated again ?
- No need, sometime I need to use the same title
2) What if someone click on a wrong row as you already have data in sheet Data in col C and D or this is only an examle ?? I need clarification on this also
- Sometime I do need to replace the existing title, if user intent to replace it, let it be.
I always add-in data at Listing sheet (column A and B), the userform should reflect accordingly.
Hi Billa7
Tks for answering my quesitons which basically cleared up all issues.
Please check this version of the file and when run Enable macros and try it out. It should be intuitive please feel free to test it even if trying to paste to a diffrent sheet than Data and see what happens. Also the list box is multiselect Extended ie you can select multiple rows and if you want also press CTRL and click on any rows it will include them in the highlighting for transfer.
Please feel free to revert with your comments.
gowlfow
UserForm.xls
Tks for answering my quesitons which basically cleared up all issues.
Please check this version of the file and when run Enable macros and try it out. It should be intuitive please feel free to test it even if trying to paste to a diffrent sheet than Data and see what happens. Also the list box is multiselect Extended ie you can select multiple rows and if you want also press CTRL and click on any rows it will include them in the highlighting for transfer.
Please feel free to revert with your comments.
gowlfow
UserForm.xls
ASKER
Hi Gowflow,
Amazing!! this is what I'm looking for. Thanks a lot .
How to adjust the width for Column A (Title) and Column B (duration) at Userform. I need at least:
Column A width : 65
Column B width :12
Please help
Amazing!! this is what I'm looking for. Thanks a lot .
How to adjust the width for Column A (Title) and Column B (duration) at Userform. I need at least:
Column A width : 65
Column B width :12
Please help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Gowflow,
I'm so sorry, what I'm referring is for Listbox in Userform. The respective column need to be in the mentioned width at least:
Column Title width : 65
Column Duration width :12
Apology for not giving a detail.
I'm so sorry, what I'm referring is for Listbox in Userform. The respective column need to be in the mentioned width at least:
Column Title width : 65
Column Duration width :12
Apology for not giving a detail.
ASKER
Hi Gowflow,
Got it, managed to modify the width. Thanks a lot for creating the flexibility in the script.
Got it, managed to modify the width. Thanks a lot for creating the flexibility in the script.
well did you check my solution ? I have it a bit complex for the width !
gowflow
gowflow
ASKER
Hi Gowflow,
Thanks for the brilliant code. It's truly amazing. Know what, I'd been spending hours and hours weekly just to create this listing manually. Looks like your solution able to remove the pain absolutely. I am envious with your talent.
Thanks for the brilliant code. It's truly amazing. Know what, I'd been spending hours and hours weekly just to create this listing manually. Looks like your solution able to remove the pain absolutely. I am envious with your talent.
ASKER
Hi Gowflow,
Any idea how to solve this problem? facing a dead-end for this....please consider.
https://www.experts-exchange.com/questions/27503871/Update-Time-value-automatically.html
First of all Do you know Cartillo ? As this file already familiar and was posted by him is any chance you know ?
Second your post is a bit confusing
You mention display data from Listing sheet (Column A and Column B) in userform at Data sheet when click “Userform” button at Data sheet.
>>> does this means Copy Col A and B from sheet Listing to Sheet Data in Col C and D or more specifically locate each cell of Col A in Listing and paste the coresponding B value in col D of Data ?
User should able to select the cell at Data sheet while the Userform still open.
>>> I do not see any UserForm in your project what are you refering to ???
gowflow