Excel VBA support only
- or -
Post a project like this£50(approx. $63)
- Posted:
- Proposals: 7
- Remote
- #1199671
- Expired
Description
Experience Level: Expert
Estimated project duration: 1 day or less
I have created some userforms in excel VBA but I'm struggling with some code.
As i am on the clock this is a today through to tomorrow by noon.
What i need is to be able to send someone a screen shot of the form and the code behind it and for them to return the efficient code to allow to userform to work as one is done and signed off i will release a milestone payment which will be based on turnaround and efficiency of the code and then i will send the next one.
Here are some of the issues that i am having. If you can only commit to doing one area please let me know but i will be paying on a per item section basis.
Labels
- Creating more labels on a form is linked to a cell but the correct results only appear in one label and wrong results in the others
- Refresh lables that are linked to a cell if they change (the link of the workbook they are associated with maybe closed)
Search and retrieve
- How to search and retrieve only certain data from a previously saved record and then populate another set of data asspciated with that record. The search will be based oon a match of three criterias and once the result is confirmed the form should either popuplate or return not available do you want to enter record? BUT the date is being pulled from another workbook that wil not be opened
Saving
- Save a record to a workbook that is not open (not worksheet) after it has been validated
- Save a record only
Validation: £5
- text box validation, textbox to have date load dd/mm/yyyy appear for today
- textbox to have time load to today on opening the form or when form cleared after submitting a record
Combo's and Lists
- fix Combo boxes issue = works sometimes and then other times does not work and the drop down is blank
- link combo boxes up if selection is made in oen it only shows the selectin associated with the first combo box
Interactive table
- Load results from a data that has been saved based on a certain criterias that have come
Videos/other documents
- insert another file or document into a form so that it ca be opened
For anyone who is expereienced at VBA i don't expect it to be overly complicated. You will not be creating the userform it is just the code. The fixed price is assuming you complete ALL the items above.
As i am on the clock this is a today through to tomorrow by noon.
What i need is to be able to send someone a screen shot of the form and the code behind it and for them to return the efficient code to allow to userform to work as one is done and signed off i will release a milestone payment which will be based on turnaround and efficiency of the code and then i will send the next one.
Here are some of the issues that i am having. If you can only commit to doing one area please let me know but i will be paying on a per item section basis.
Labels
- Creating more labels on a form is linked to a cell but the correct results only appear in one label and wrong results in the others
- Refresh lables that are linked to a cell if they change (the link of the workbook they are associated with maybe closed)
Search and retrieve
- How to search and retrieve only certain data from a previously saved record and then populate another set of data asspciated with that record. The search will be based oon a match of three criterias and once the result is confirmed the form should either popuplate or return not available do you want to enter record? BUT the date is being pulled from another workbook that wil not be opened
Saving
- Save a record to a workbook that is not open (not worksheet) after it has been validated
- Save a record only
Validation: £5
- text box validation, textbox to have date load dd/mm/yyyy appear for today
- textbox to have time load to today on opening the form or when form cleared after submitting a record
Combo's and Lists
- fix Combo boxes issue = works sometimes and then other times does not work and the drop down is blank
- link combo boxes up if selection is made in oen it only shows the selectin associated with the first combo box
Interactive table
- Load results from a data that has been saved based on a certain criterias that have come
Videos/other documents
- insert another file or document into a form so that it ca be opened
For anyone who is expereienced at VBA i don't expect it to be overly complicated. You will not be creating the userform it is just the code. The fixed price is assuming you complete ALL the items above.
Allie T.
100% (8)Projects Completed
12
Freelancers worked with
12
Projects awarded
44%
Last project
27 Jul 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies