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
React WhatsApp Cloud API Automation Category: Amazon Web Services, Backend Development, Docker, Frontend Development, JavaScript, Node.js, PHP, REST API Budget: $10 - $30 USD
26-Apr-2026 10:04 GMT
UrbanPlatter---Food-Delivery-App Category: Artificial Neural Network, Backend Development, CSS, Frontend Development, HTML5, Python, Web Application, Web Design, Web Development Budget: ₹12500 - ₹37500 INR
26-Apr-2026 10:04 GMT
Publicación Técnica de Libro en KDP Category: Book Design, Editing, Graphic Design, PDF, Print Design, Proofreading, Publishing, Technical Writing Budget: €30 - €250 EUR
26-Apr-2026 10:04 GMT
Accurate PDF/Excel Data in Access Category: Data Analysis, Data Entry, Data Extraction, Data Integration, Data Management, Data Processing, Database Management, Excel, Microsoft Access, PDF Budget: ₹100 - ₹400 INR
26-Apr-2026 10:02 GMT
Amazon Jewellery Listing & SEO Category: Amazon, Content Writing, Copywriting, Digital Marketing, EBay, Internet Marketing, Keyword Research, Product Descriptions, SEO Budget: ₹12500 - ₹37500 INR
26-Apr-2026 10:01 GMT
Corporate Video Editor Needed Category: Adobe Premiere Pro, After Effects, DaVinci Resolve, Final Cut Pro, Video Editing, Video Post Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR
26-Apr-2026 09:59 GMT
Instagram Content Creation & Management Category: Photoshop, After Effects, Animation, Content Creation, Graphic Design, Social Media Management, Video Editing, Video Production Budget: ₹600 - ₹1500 INR
26-Apr-2026 09:58 GMT
DQ200 UDS Diagnostic Test Bench Category: Data Analysis, Documentation, Embedded Systems, Microcontroller, Python, Regression Testing, Reverse Engineering, Signal Processing, Software Development, Test Automation Budget: €1500 - €3000 EUR
Full-stack WordPress Development for Arborman Category: Analytics, API Integration, Content Creation, Digital Marketing, Google Analytics, Lead Generation, SEO, Web Design, Web Development, WordPress Budget: $250 - $750 USD
Instagram Reels Video Editor Category: Adobe Premiere Pro, After Effects, CapCut, Final Cut Pro, Video Ads, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services Budget: ₹600 - ₹1500 INR
26-Apr-2026 09:48 GMT
Comprehensive SEO Overhaul Needed Category: Analytics, Content Strategy, Conversion Rate Optimization, Google Analytics, Internet Marketing, Keyword Research, Link Building, SEO Budget: ₹1500 - ₹12500 INR
