Im stuck with some code in VBA. Every time i manually change the value in textBox20 it resets when i hit the SaveQuote button. The subroutine ComboBox20_Change is being triggered programatically elsewhere in the project that is doing it and i cant figure out how to stop it.
Private Sub ComboBox20_Change() If Not isUserChange Then Exit Sub ' Only proceed if the user triggered the change
Dim ws As Worksheet Dim lookupValue As String Dim result As String Dim qValue As String Dim installValue As Double Dim Rng As Range Dim cell As Range Dim found As Boolean
Me.TextBox2000.Value = 1 Me.TextBox3000.Value = 1
Set ws = ThisWorkbook.Sheets("GHMatrix") lookupValue = Trim(Me.ComboBox20.Value)
If lookupValue = "" Then Me.TextBox200.Value = "" Me.TextBox20.Value = "" Me.TextBox300.Value = "" Me.ComboBox30.Value = "" Me.TextBox30.Value = "" Exit Sub End If
found = False For Each cell In ws.Range("H1:H" & ws.Cells(Rows.Count, "H").End(xlUp).row) If Trim(cell.Value) = lookupValue Then Set Rng = cell found = True Exit For End If Next cell
If found Then result = ws.Cells(Rng.row, 1).Value qValue = ws.Cells(Rng.row, 21).Value installValue = ws.Cells(Rng.row, 22).Value
Me.TextBox200.Value = result Me.TextBox20.Value = qValue
Classic Raised Panel Kitchen Redesign Category: 3D Design, 3D Rendering, 3D Visualization, Building Architecture, Building Design, Building Information Modeling, Graphic Design, Interior Design Budget: $30 - $250 USD
Convert bibliography files Category: Academic Research, Copy Editing, Data Cleansing, Data Entry, Excel, Google Spreadsheets, Microsoft Word, OCR, PDF, Proofreading Budget: $250 - $750 USD
25-Dec-2025 22:56 GMT
eBay Dropshipping Store Development Category: Dropshipping, EBay, ECommerce, Order Processing, Product Descriptions, Product Research, Sales, Supplier Sourcing Budget: £20 - £250 GBP
Modern Home Interior Renovation Category: 3D Rendering, Architecture, AutoCAD, Building Architecture, Building Design, Interior Design, Revit, SketchUp Budget: €250 - €750 EUR
25-Dec-2025 22:50 GMT
Engaging 3D Animation for Kids Category: 3D Animation, 3D Design, 3D Graphic Design, 3D Illustration, 3D Modelling, 3D Rendering, Animation, Character Illustration, Voice Over, YouTube Video Editing Budget: $15 - $25 USD
25-Dec-2025 22:45 GMT
Hook up API Truck Vin and Info Category: API Integration, Data Analysis, Data Extraction, Data Processing, Database Development, Excel, Python, Report Development, SQL Budget: ₹37500 - ₹75000 INR
