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
Billa7Asked:
Who is Participating?
 
gowflowCommented:
Hi Billa7

Is this better ?
gowflow
UserForm.xls
0
 
gowflowCommented:
Hi Billa7

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
0
 
Billa7Author Commented:
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.  
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
gowflowCommented:
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
0
 
Billa7Author Commented:
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.
0
 
gowflowCommented:
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
0
 
Billa7Author Commented:
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
0
 
Billa7Author Commented:
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.

0
 
Billa7Author Commented:
Hi Gowflow,

Got it, managed to modify the width. Thanks a lot for creating the flexibility in the script.  
0
 
gowflowCommented:
well did you check my solution ? I have it a bit complex for the width !
gowflow
0
 
Billa7Author Commented:
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.
0
 
Billa7Author Commented:

Hi Gowflow,

Any idea how to solve this problem? facing a dead-end for this....please consider.

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27503871.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.