I need a Syntax for a Userform I'm working on

I need a Syntax code for a Userform I'm working on.

Its essentially a VLookup, with Dynamic Lookup Value, Dynamic sheet reference, and nested IF Functions for Column Reference.

-The Lookup Value comes from a text box from within the userform that is already dependent on the result in other textboxes via VLookup function. I currently have this set up as a text box that I dont really want seen, but its a value already drawn from a vlookup type function to find a product number for a product description. If there is anyway of removing this textbox and adding this to the full syntax code this would be great.

Product Number( Combobox98, the one i would like to remove if possible) = Vlookup Product Description (Combobox17), (Sheet "Index, range B18:C100) in column 2 (C) (written in syntax form within the code for change events on Combobox98)

- The Sheet reference value comes from combobox15 (the values are a dynamic list of accounts drawn from within a worksheet) from within the userform

- The Column reference comes from Combobox5 (the values are a list of container types drawn from within a worksheet {Closed Top, Open Top, Over Height & Jumbo}) within the userform, so needs some kind of nested IF function (Closed Top = Column 3 (C), Open Top = Column 4(D), Over Height = Column 5(E) & Jumbo = Column 6(F))

This function will return a price per m2 drawn from a heap of worksheets, each account has its own worksheet, with product codes down Column A, four different columns of pricing depending on the container size).

Also any help with the Email on Submit button would be great. Comboboxes 11, 12 ,13 &14 will provide the email addresses, but the body of the email should have the info from within the Userform, ideally laid out in the same way.

I have attached the file, but if there are any questions please ask.


Taidot: Excel, Visual Basic

Näytä lisää: excel vba userform to input data, excel userform data entry, advanced excel userform examples, excel vba userform examples pdf, userform initialize not working, excel userforms templates, excel vba userform initialize vs activate, excel vba userform examples, hello freelancer i need simple logo design and i have a pretty good idea what type of design i want, hello freelancer i need simple logo design and i have a pretty good idea what type of design i, where do i fi d an animator, evden yazılım işi, freelance grafik tasarım işi, freelance tasarım işi, freelance web tasarım işi arıyorum, freelance yazılım işi, i want d logos of all d political parties in nigeria, if i m working free lance i can give invoice, i have two million i need to start business so i need advice, i need an artist where can i find one

Tietoa työnantajasta:
( 0 arvostelua ) Balwyn North, Australia

Projektin tunnus: #19754555

16 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Lisää

$250 AUD 7 päivässä
(314 arvostelua)

Hi, You may not select the right candidate without knowing what your project on writing syntax codes for your Excel user form will look like. Fortunately, I can complete a part of your job before you award the project. Lisää

$150 AUD 2 päivässä
(47 arvostelua)

This is a very intense workbook.. well done! However, as you are now discovering, maintenance and development for any new features is becoming a major undertaking. Respectfully, please consider using a backend databas Lisää

$800 AUD 7 päivässä
(49 arvostelua)

I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I might have a few question to discuss so I need you to send a message on chat.

$111 AUD 3 päivässä
(76 arvostelua)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Lisää

$250 AUD 3 päivässä
(97 arvostelua)

Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Lisää

$120 AUD 3 päivässä
(69 arvostelua)

Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br

$111 AUD 4 päivässä
(23 arvostelua)

Hello! I read your description carefully. I've always done my project the fastest and highest quality. I think your project is best for me. The reason is that I am a VB expert. If you want to check my skill, you c Lisää

$200 AUD 3 päivässä
(2 arvostelua)

hi I have a lot of experience in data processing, checking and fixing errors in excel. I can help you fix this error very quickly and accurately. Hope can be cooperated with you.

$111 AUD 2 päivässä
(1 arvostelu)

hi there I am an expert in excel macro and VBA. I have completed many project on VBA dynamic excel coding. I have read your project and I am sure that I can complete this on time. I am an expert in nested vlookup formu Lisää

$111 AUD 3 päivässä
(1 arvostelu)

I Do visual design of real website in PSD/PNG format which is also known as PSD web template.I will design modern UI/UX layout for your website. I Will Design A Mobile Friendly UI Landing Page Or Website I can design a Lisää

$140 AUD 7 päivässä
(0 arvostelua)

Hello. Welcome! I'm excited that you’re here! ✅ I am confident you will be most satisfied with the work we do. Please come over chat for further detailed discussion to start working on it. If you hire me,I wil Lisää

$155 AUD 3 päivässä
(0 arvostelua)

Hello! I have briefly read the description on syntax-for-userform development project, and I can deliver as per the requirements however I need us to discuss for more clarity on the details, deadline and budget Lisää

$200 AUD 3 päivässä
(0 arvostelua)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do th Lisää

$140 AUD 7 päivässä
(0 arvostelua)

Writing Invaders is a group of independent professional writers and website developer and scholars from everywhere throughout the world. Together, we give best quality aid to secondary school, undergraduate, Masters Lisää

$140 AUD 7 päivässä
(0 arvostelua)

Hello, I have 15 years experience working with macros. I usually create my own forms and write them in VBA from scratch but I can work with your user form. I have written macros before that send emails. Do you want a Lisää

$200 AUD 7 päivässä
(0 arvostelua)