create a user form

已关闭 已发布的 Jul 13, 2015 货到付款
已关闭 货到付款

We run a different campaign in our organization like collections campiagn, upsell etc.. All the campaigns is being mentioned in the excel sheet which is attached.

What user is doing now:- In the collections Campaign- When the campaign is assigned to an agent the fields from Column A to S is already filled. The Agent has to open the account in our tool, using the account ID (in column E) and then call the customer. after calling the customer the agent fills the fields like "Current Outstanding" (in Column T), "Amt customer Already Paid" (in column u)...etc.. so agent has to fill the fields from Column T to AP..

What I want:- I want create a user form in sheet 1, which has all the drop downs.. for example..if the agent is doing collections campaign.. he should have a drop down which has all the A/C numbers.. The moment he selects the account number the user should get a 4 text box in which content of column F, G,H and I should auto populate.. We must also have combination of text boxes and combo boxes (anything which you think is approproiate) to accomodate the option for columns from T to AP..The momemnt agent strats filling the boxes and clicks on the submit button in the user form.. the data should be filled in the collections sheet

Visual Basic的应用程式

项目ID: #8062453

关于项目

10个方案 远程项目 活跃的Aug 19, 2015

有10名威客正在参与此工作的竞标,均价₹2224/小时

zExcel

A proposal has not yet been provided

₹5000INR 在1天里
(10条评论)
4.1
Ayan

Hello, I am interested in this project. Please let me know when we can discuss further about the requirements. Thank you.

₹1500INR 在1天里
(18条评论)
3.8
abhinovpankaj

Hi, I am working as software professional in IT industry from last 4 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio 更多

₹1500INR 在1天里
(2条评论)
2.6
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr 更多

₹6842 INR 在5天内
(1条评论)
0.7
zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Acc 更多

₹1300INR 在1天里
(0条评论)
0.0
rgcampelo

Hi, In my day time work my main job is to automate task in my company. So, 80% of my work is to automate excel data entry, macros, work with data, etc. I'm sure I'll do the job as you want to. Thank you, Rafa 更多

₹1200 INR 在2天内
(0条评论)
0.0
ghsoftlab

Hi, I'm an electronic and computer engineer with expert knowledge of Microsoft Excel and VBA programming. I reviewed specification You gave and I'm very interested to work on your project. I can assure You that,if 更多

₹1000 INR 在5天内
(0条评论)
0.0
punna111

I have good experience in MS Excel, Access and VBA, I hope i could help you on this project. Please let me know.

₹1300INR 在1天里
(0条评论)
0.0
wenguo214

A proposal has not yet been provided

₹3250INR 在1天里
(0条评论)
0.0