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
Figma Watch Face Reconstruction Category: Design Thinking, Digital Design, Figma, Graphic Design, Illustration, Photoshop, UI / User Interface, Vector Design, Visual Design Budget: ₹600 - ₹900 INR
12-Jan-2026 11:03 GMT
Gather data from a freelancers site Category: Data Analysis, Data Collection, Data Entry, Data Extraction, Data Management, Data Mining, Data Processing, Data Scraping, Excel, Web Scraping Budget: $10 - $30 USD
12-Jan-2026 11:03 GMT
AI Thumbnails & Animation Category: 3D Animation, Photoshop, After Effects, AI Animation, AI Art Creation, Animation, Graphic Design, Video Editing Budget: ₹12500 - ₹37500 INR
Fitness Reels & Shorts Editing Category: Adobe Premiere Pro, Audio Editing, Color Grading, Commercials, Final Cut Pro, Video Editing, Video Post Editing, Video Production, Video Services, Voice Over Budget: ₹600 - ₹1500 INR
Canva designers Category: Canva, CapCut, Graphic Design, Photoshop, Photoshop Design, Social Media Management, Video Editing, Visual Design Budget: ₹400 - ₹750 INR
12-Jan-2026 10:55 GMT
Media Server (Ventuz ) Live Event Category: Installation, Performance Tuning, System Administration, Technical Support, Troubleshooting, Video Production, Windows Server Budget: $250 - $750 USD
