Đang Thực Hiện

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

Kỹ năng: Visual Basic

Xem thêm: job values, excel form enter data, vba coding job, simple coding vba excel, excel 2003 vba coding, excel 2003 vba, vba for, in vba, visual basic form excel, vba excel, save excel, price excel, popup formula, job visual basic, excel formula, excel based, excel vba, estimating, excel data table lookup, coding visual basic excel, visual basic excel coding, excel 2011 vba, basic vba coding, vba basic coding, basic excel coding

Về Bên Thuê:
( 28 nhận xét ) Wandi, Australia

Mã Dự Án: #1076623

Đã trao cho:

LIMEXS

Please, Check my PM

$30 AUD trong 0 ngày
(5 Đánh Giá)
2.7

3 freelancer đang chào giá trung bình $33 cho công việc này

vserv

Pls see your messages. Thanks

$40 AUD trong 2 ngày
(28 Đánh Giá)
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 trong 0 ngày
(0 Đánh Giá)
0.0