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
Operations Systems Architect for Multifamily Property Category: Airtable, Asana, Business Analysis, Business Plans, ClickUp, Excel, Monday.com, Notion, Operations Management, Project Management Budget: $1500 - $3000 USD
14-May-2026 15:59 GMT
Tech & Business Content Writer Category: Article Writing, Blog Writing, Content Writing, Copywriting, Keyword Research, SEO, Social Media Marketing, Technical Writing Budget: $30 - $250 USD
14-May-2026 15:58 GMT
PHP Database Refactor With AI Tagging Category: AI Content Creation, AI Development, AI Model Development, AI Text To Text, Database Design, Database Management, HTML, MySQL, PHP, Software Architecture Budget: $30 - $250 USD
Insert 909 Photos into Excel Category: Data Entry, Data Processing, Excel, Excel Macros, Excel VBA, Image Processing, Microsoft Office, PDF Budget: $10 - $30 USD
Urgent 3D Product Prototype Category: 3D Animation, 3D CAD, 3D Design, 3D Drafting, 3D Graphic Design, 3D Model Maker, 3D Modelling, 3D Printing, 3D Rendering, Product Design Budget: $10 - $30 USD
Finalize AI Hip Imaging Review Category: Academic Writing, Content Writing, Data Analysis, Medical Research, Medical Writing, Report Writing, Research, Research Writing, Statistical Analysis, Technical Writing Budget: $30 - $250 AUD
Fitness Mobile App Development Category: Fitness, Graphic Design, IPhone, Mobile App Development, Mobile Development, UI / User Interface, User Experience Research, User Interface / IA Budget: $25 - $50 USD
Samsung TV Store Submission Help Category: App Development, App Store Optimization, Documentation, Game Development, Technical Support Budget: $30 - $250 USD