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
Game Play Tester & Use-Case Developer Category: API Integration, CSS, Frontend Development, HTML5, JavaScript, JSON, PHP, User Experience Research, User Interface / IA, Web Development Budget: $250 - $750 USD
Short Drama Streaming App Creation Category: Backend Development, Frontend Development, IOS Development, Mobile App Development, Video Streaming Budget: $250 - $750 USD
20-Feb-2026 23:00 GMT
Gestión Instagram y Contenido Category: Adobe Creative Cloud, Adobe Dynamic Tag Management, Content Creation, Graphic Design, Instagram Marketing, Logo Design, Social Media Management Budget: $8 - $15 USD
20-Feb-2026 23:00 GMT
3D Space Crystal GIF Category: 3D Animation, 3D Design, 3D Graphic Design, 3D Modelling, 3D Visualization, After Effects, Animation, GIF Animation Budget: $30 - $250 USD
One-Day Rock Song Production Category: Audio Editing, Audio Production, Audio Services, Editing, Music, Music Production, Sound Design, Sound Engineering Budget: £20 - £250 GBP
20-Feb-2026 22:52 GMT
Logo - for hair Salon Category: Adobe InDesign, Photoshop, Graphic Design, Logo Design Budget: $250 - $750 USD
20-Feb-2026 22:50 GMT
Ai short video Category: AI Animation, AI Art Creation, AI Content Creation, AI Design, AI Development, AI Graphic Design, AI Text To Video, Video Editing, Video Production, Video Services Budget: €8 - €30 EUR
20-Feb-2026 22:49 GMT
Karikatur Digital Unik Category: 2D Animation, 2D Drawing, Character Illustration, Graphic Design, Illustration, Logo Design, Photoshop, Sketching Budget: $1500 - $3000 USD
20-Feb-2026 22:45 GMT
"Blind-Phase" Conflict Resolution Clincial Trials Development Category: API Development, Compliance, Data Analysis, Data Management, Database Development, Database Management, Encryption, Project Management, Software Development, User Interface / IA Budget: $20000 - $50000 USD
20-Feb-2026 22:43 GMT
Smartlead.ai Campaign Audit & Test Category: A / B Testing, Data Analysis, Digital Marketing, Email Marketing, Google Adwords, Internet Marketing, Marketing, Report Writing Budget: $30 - $250 USD
