Create buttons for an action using visual basic for microsoft excel files.
To those who is excel in visual basic language.
Freelance Needed.
Objective:-
Project Description.
Please refer to the example 1 & 2 (attachment) for more in depth understanding about the excel program we use.
Project A
The excel files contain information of customer account no, customer ID, name, service no,
agent id, activation date, registration date, package, basic monthly charge for each column
respectively.
Job A
Multiple VB buttons that can change the way we used to live to the new user friendly interfaces.
Please follow the sample required.
Sample 1
A button that can change format cells automatically in a way such as:-
column "A" = Number without decimal point
column "B" = Text
column "C" = Text
column "D" = Text
column "F" = Date (DD/MM/YYYY)
column "G" = Date (DD/MM/YYYY)
column "H" = Text
column "I" = Number with two decimal point
Sample 2
A button that clear format only for all columns and set default to font type = "calibri" and
font size = "11".
Sample 3
A button that has function of autofit row height and column width for all cells with capable
of removing spaces between content and cell.
Sample 4
A button that has function of auto-insert multiple values into respective cell separately for
column I named "basic monthly charges" by refering to column H named "Package" in a way
such as
Package (column H) Auto-Insert Value into (column I)
VIP 5-New 149.00
VIP 10-New 199.00
VIP 20-New 249.00
VIP 5-Migrate 149.00
VIP 10-Migrate 199.00
VIP 20-Migrate 249.00
VIP 10-Upgrade 199.00
VIP 20-Upgrade 249.00
BIZ 5 (Dynamic IP) 199.00
BIZ 10 (Dynamic IP) 289.00
BIZ 20 (Dynamic IP) 359.00
BIZ 10 (Fixed IP) 599.00
BIZ 20 (Fixed IP) 899.00
Streamyx Home 1.0M RM110 110.00
Streamyx Home 2.0M RM130 130.00
Streamyx Home 4.0M RM140 140.00
Business Broadband SOHO OIAB 365 1.0M RM150 198.00
Business Broadband SOHO OIAB 1.0M RM120 198.00
Business Broadband 1IP 2.0M RM688 688.00
Project B
The excel files contain information of order number, installation done date, voice over broadband no,
billing account no, state (PTT), status, customer name, commission to(ID), primary customer ID no,
package, logic, commission, team name for each column respectively.
Job B
Please follow the sample required.
Sample 1
A button that has function of auto combine/merge two columns into one column for column J named "Package" and
column K named "Logic" in a way such as
Please add "-" in between
Package (column J) Logic (column K) Auto combine/merge (New column name as Package)
VIP 5 New VIP 5-New
VIP 5 Migrate VIP 5-Migrate
VIP 10 New VIP 10-New
VIP 10 Migrate VIP 10-Migrate
VIP 10 Upgrade VIP 10-Upgrade
VIP 20 New VIP 20-New
VIP 20 Migrate VIP 20-Migrate
VIP 20 Upgrade VIP 20-Upgrade
--The End--
Thank You.
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
Good day,
I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. I work with excel since 1999.
Here are the links for my past experiences:
https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html
https://www.freelancer.com/projects/4848189.html
https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html
https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html
https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html
Regards.
Hello,
I am an excel expert.
I have created Sample 1,2,3 for Project A.
Can you please clear Sample 4 for project A?
I will work on Project B after completing project A.
Looking forward for the reply.
Regards,
Aditya
Hi,
I can do this job for you. I have extensive experience in MS Excel and VBA programming.
Please let me know if interested in hiring me.
Thanks.
Regards,
jawad
Most of what is desired can be accomplished except that fof default formating of the workbook, for which a file has to be placed in the start directory and the workbok closed and reopened again
Hi I have worked on many Excel VBA Projects from simple to complex. I have also completed a Project for a Fortune 500 company - Emerson. Here at freelancer.com, I have successfully completed 3 projects. I love to work on challenging projects. I read you Project description, I would like to work on it and complete it as mentioned. I am eager to discuss the project and also I have got few suggestions. Let me know if your interested form my proposal. Looking forward to hear from you. Thanks.
I have worked extensively with Visual Basic for Applications for all MS Office products and this project is fairly straight forward.
A small user-interface can be made to "float" on top of the spreadsheet. This interface will contain all the required button in the foreground and the necessary code in the background.
This is very simple and doesn't actually need a high level of VBA expertise to be honest. These are some basic things which are required while designing dashboards. So I will be able to do it in 2 hours . Let me know if this suits you.