I cant find those named ranges either, and in fact there is no sheet with the name "cost" , so I expect you gave me the wrong file.... or my ignorance in UserForms is showing up, because I still cant see how to get at that macro...
The file has a worksheet with the name Form, but there are two UserForms, UserForm2 and UserForm3
I appologise if it is down to my ignorance and lack of experience with such files.
I know VBA quite well
I do have some Userforms of my own and I know how to get at all the coding behind them, but I still can't find your
Private Sub txtdelta_AfterUpdate()
I cant see anything like your last screenshots anywhere in either the worksheets or in the VB Editor of the file ylou have given.... ( The file I have from you has the name Part tracker test2.xlsm )
According to my ( limited ) knowledge of VBA if I have a code line like this
ThisWorkbook.Sheets("Cost")
then I must have a worksheet with a tab name of "Cost" or else that code line will error
I think also, that I must see in the Names manager the named ranges of "vrech and "col" or else
Range("vrech")
and
Range("col")
will error.
But once again, maybe in my ignorance, I am missing something obvious....




Reply With Quote
Bookmarks