Data Validation Error

[NowIC]

When I open the Cost_Codes.csv file (doesn’t mater which one) and after I run the XLSB macro:
1. The ‘minor code’ drop down list now points to the “Item Type” list (Labor, Material, Equipment, Sub, Other),
2. and the ‘subminor code’ drop down list points to the ‘Sketchup Attribute’ list (quantity, yards, etc.)

I have recopied the PERSONAL.XLSB (5/19/2019) from the plugin folder again to the Excel/Startup folder to be sure I have not modified it somehow.

I don’t seem to be able to capture a screen shot.
I am running Office 365 and Sketchup 2021.

I did not have this problem a year ago, and am just starting to use Estimator, again.

thank you,

[NowIC]

I was able to upgrade to the Personal.XLSB from 2/10/2021, but still have the same error. I am not a macro programmer, but I was looking at the code and it appears that the columns that the macro should only be run in the Items…csv, not the Cost_Code….csv. based on the column numbers assigned by the macro.

Columns(“E:E”).Select
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:=”Material,Labor,Equipment,Sub,Other”

[John Brock]

Are you trying to run the macro on the Cost Code database file, or the Item Code file? It is not programmed to work with the Cost Code file, but rather, just the Item Code file. That could be your issue. Confirm that, and if you have any additional questions, email me directly at the following address:
john@estimatorforsketchup.com

-John

[Author]

Posts