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
3D AI Animation Video Category: 3D Animation, 3D Design, 3D Modelling, After Effects, Animation, Video Services Budget: ₹1500 - ₹12500 INR
07-May-2026 04:03 GMT
Investment Management Operations Consultant Category: Accounting, Bookkeeping, Business Analysis, Compliance, Finance, Financial Consulting, Financial Planning, Hedge Fund Management, Investment Management, Research Writing Budget: $30 - $250 USD
07-May-2026 04:01 GMT
Bangladeshi Web Software Marketer Category: A / B Testing, Analytics, Content Marketing, Facebook Marketing, Google Ads, Google Adwords, Internet Marketing, Social Media Marketing Budget: $30 - $250 USD
07-May-2026 04:01 GMT
Modern Website UI in Figma Category: Figma, Graphic Design, HTML, Prototyping, UI / User Interface, User Interface / IA, Web Design Budget: ₹600 - ₹1500 INR
07-May-2026 03:57 GMT
Social Media Graphics Bundle Category: Photoshop, Branding, Graphic Design, Illustration, Logo Design, Social Media Marketing, YouTube Video Editing Budget: ₹1250 - ₹2500 INR
07-May-2026 03:57 GMT
Digital Marketing Specialist for E-Commerce Platform Category: Advertising, Digital Marketing, Facebook Marketing, Google Ads, Internet Marketing, Link Building, SEO, Social Media Marketing Budget: ₹1500 - ₹12500 INR
07-May-2026 03:56 GMT
Migrate AI-Builder Site and Setup Dashboard Category: AI (Artificial Intelligence) HW / SW, Backend Development, Graphic Design, HTML, JavaScript, Payment Gateway Integration, PHP, Web Hosting, Web Design, Website Optimization Budget: ₹4500 - ₹12000 INR
07-May-2026 03:56 GMT
Mobile App with Comment Section -- 2 Category: Android, Flutter, IOS Development, IPhone, Mobile App Development, Objective C, React Native, User Interface / IA Budget: ₹750 - ₹1250 INR
07-May-2026 03:54 GMT
WhatsApp Chat Responder Needed Category: Customer Service, Customer Support, Social Media Management, Time Management, Virtual Assistant Budget: $15 - $25 USD
07-May-2026 03:50 GMT
Business Partner - StrongBody Brazil Category: B2B Marketing, Business Analysis, Business Development, Business Plans, Copywriting, CRM, Lead Generation, Market Research, Research, SaaS Budget: $1500 - $3000 USD
