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
Cinematic House Project Video Edit Category: 3D Animation, Adobe Premiere Pro, After Effects, Animation, Color Grading, Video Editing, Video Post Editing, Video Production Budget: $10 - $30 AUD
Canal YouTube Monetizado para Stand-up -- 2 Category: Content Creation, Digital Marketing, SEO, Video Editing, Video Production, Video Services, YouTube, YouTube Ads Budget: $250 - $750 USD
15-Mar-2026 16:53 GMT
Modern Living Room Interior Design Category: 2D Drafting, 3D Design, 3D Rendering, 3D Visualization, Building Architecture, Interior Design Budget: €2 - €6 EUR
15-Mar-2026 16:50 GMT
Meta Ads Lead-Gen Setup Category: Advertising, Digital Marketing, Facebook Ads, Google Adwords, Google Analytics, JavaScript, Lead Generation, PHP Budget: ₹600 - ₹1500 INR
15-Mar-2026 16:49 GMT
Software Usabiliy Testing Needed Category: Accessibility Testing, Software Testing, Testing / QA, Usability Testing, User Experience Research, User Interface / IA, User Research, Web Testing, Website Testing Budget: ₹750 - ₹1250 INR
15-Mar-2026 16:49 GMT
Future World Nonfiction Book Category: Article Writing, Business Writing, Content Writing, Copy Editing, Editing, Ghostwriting, Non Fiction Writing, Research, Technical Writing, Writing Budget: ₹37500 - ₹75000 INR
15-Mar-2026 16:47 GMT
Tingkatkan Fitur Aplikasi Saya Category: Agile Development, API Development, App Development, Backend Development, Frontend Development, Project Management, Software Development, User Experience Research Budget: $10 - $30 USD
15-Mar-2026 16:47 GMT
Creative T-Shirt & Sticker Idea for Pump Track Riders Category: Branding, Concept Art, Creative Design, Graphic Design, Illustration, Logo Design, Photoshop, Sticker Design, T Shirts, Visual Arts Budget: $15 - $25 USD
