Fermé

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.

Glenn

Compétences : Excel, Visual Basic

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Balwyn North, Australia

Nº du projet : #19754555

16 freelance font une offre moyenne de $199 pour ce travail

schoudhary1553

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(314 Commentaires)
7.8
dvcontact

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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(47 Commentaires)
6.3
wsh2

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(49 Commentaires)
6.3
seoguru17

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(76 Commentaires)
6.3
aubrey03

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] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(97 Commentaires)
5.7
vsprybhanu

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(69 Commentaires)
5.4
webanis

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 4 jours
(23 Commentaires)
4.1
fastestJohn

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(2 Commentaires)
2.7
diepkha

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(1 Évaluation)
0.6
malviya786

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(1 Évaluation)
0.4
developersperhr

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0
sharktiger

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
0.0
VirtualBrainInc

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
0.0
techlinesols6

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0
writinginvaderz

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0
GKEvans

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0