En cours

Excel 2003 VBA Coding Very Simple Job

I have a workbook the workbook has a Quotation Number cell which i need the user to enter the quote number and save the workbook as that quote number before being able to enter any other data in the workbook.

i use this for estimating on the first worksheet it has a category drop down box, a product description drop down box which is based on the category selection which in turn looks up values from a table and then populates the unit cell, price cell and labour cell.

What i would like to be able to do is change either the price or labour value or both without overwriting the lookup formula and before i move out of the cell a popup form comes up and says do you want to save changes to lookup table Yes or No. If yes it updates changes in lookup table. If No the value entered is saved to the open workbook .All this needs to happen without deleting the lookup formula in the price and labour cells.

I hope i have explained this clearly enough

Compétences : Visual Basic

Voir plus : what is coding, price for vba for excel, job values, excel form to enter data, vba coding job, simple coding vba excel, excel 2003 vba coding, excel 2003 vba, what is vba in excel, what is vba, vba for, in vba, visual basic form excel, VBA and excel, save to excel, price excel, popup formula, job visual basic, excel to vba, excel table, excel formula, excel based, Excel and VBA, estimating, c or c++coding

Concernant l'employeur :
( 30 commentaires ) Wandi, Australia

N° du projet : #1076623

Décerné à :

LIMEXS

Please, Check my PM

30 $ AUD en 0 jours
(5 Commentaires)
2.7

3 freelance ont fait une offre moyenne de 33 $ pour ce travail

vserv

Pls see your messages. Thanks

40 $ AUD en 2 jours
(28 Commentaires)
4.9
florinache

Hello! Your task is easy enough! I can complete it pretty fast! I you will choose me, please contact me on: Skype: ID: florance1980 Yahoo Mess: sandescuflorin Thank you in advance!

30 $ AUD en 0 jours
(0 Commentaires)
0.0