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
Bilingual Consultancy Website + Resource Library Category: Amazon Web Services, Backend Development, CI / CD, Cloud Security, CMS, Dynamics, Frontend Development, SEO Writing, System Administration, Web Security Budget: $8 - $15 USD
09-Feb-2026 11:00 GMT
European Investor Database Research Category: Data Analysis, Data Collection, Data Entry, Database Management, Excel, Lead Generation, Research, Web Search Budget: €30 - €250 EUR
B2B Social Media Design and Video Editing Category: Adobe Creative Suite, B2B Marketing, Content Creation, Graphic Design, Social Media Marketing, Video Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR
09-Feb-2026 10:59 GMT
Indian Accent Male Voiceover Artist Category: Audio Production, Audio Services, Customer Service, Hindi Translator, Voice Acting, Voice Assistance Devices, Voice Over, Voice Talent Budget: ₹400 - ₹750 INR
09-Feb-2026 10:58 GMT
Metal Rescue Tower Review and Stamp Category: AutoCAD, Building Engineering, CAD / CAM, Civil Engineering, Construction Engineering, Engineering, Project Management, Safety Consulting Budget: $250 - $750 USD
09-Feb-2026 10:58 GMT
Databricks Architect for Data Engineering Category: Architecture, Big Data, Cloud Computing, Data Analytics, Data Architecture, Data Integration, Data Management, Data Processing Budget: ₹750 - ₹1250 INR
09-Feb-2026 10:57 GMT
ICE Raids: fear as a feature not a bug Community Impact Essay Category: Article Writing, Content Writing, Essay Writing, Ghostwriting, Immigration Law, Journalism, Non Fiction Writing, Public Relations, Research Writing, Technical Writing Budget: $250 - $750 USD
Public Consultation Report Category: Consulting, Data Analysis, Data Collection, Grant Writing, Public Relations, Qualitative Research, Report Writing, Research Budget: £1500 - £3000 GBP
