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
Optimasi Email Marketing Penjualan -- 2 Category: A / B Testing, Copywriting, Data Entry, Email Marketing, Internet Marketing, Marketing, Marketing Strategy, SEO Budget: $2 - $8 USD
12-May-2026 10:04 GMT
Freelance Technical Trainer for CSuite Tech Labs Category: Artificial Intelligence, Cloud Computing, Data Analytics, Data Science, Freelance, Java, Python, Training, Web Development Budget: ₹750 - ₹1250 INR
12-May-2026 10:03 GMT
AI Governance Tool Development Category: API Development, Docker, Java, Kubernetes, Machine Learning (ML), MySQL, Python, Software Architecture Budget: ₹12500 - ₹37500 INR
12-May-2026 10:02 GMT
Sales-Driven Meta/TikTok Influencer Reviews Category: Content Creation, Google Adwords, Influencer Marketing, Internet Marketing, Marketing, SEO, Social Media Marketing, Video Production Budget: $15 - $25 USD
12-May-2026 10:01 GMT
Casual Instagram Video Editor Category: Content Creation, Social Media Marketing, Video Ads, Video Editing, Video Services, Videography Budget: ₹1500 - ₹12500 INR
12-May-2026 10:01 GMT
Industrial Supermarket 3D Walkthrough Category: 3D Animation, 3D Architecture, 3D Design, 3D Graphic Design, 3D Modelling, 3D Rendering, 3D Visualization, 3ds Max Budget: ₹12500 - ₹37500 INR
12-May-2026 10:00 GMT
Nintex Developer for Workflow Automation Category: API Integration, C#, Programming, JavaScript, Microsoft 365, Nintex Forms, Power Automate, Sharepoint Budget: €2 - €6 EUR
Local SEO Ranking Boost Category: Content Marketing, Google Analytics, Internet Marketing, Keyword Research, Link Building, Marketing, SEO, Website Audit Budget: €30 - €250 EUR
12-May-2026 09:56 GMT
Workforce Management App Development Category: AI Development, Android, API Development, Backend Development, Base44, Database Management, Flutter, Full Stack Development, Geolocation, Mobile App Development, React Native, Web Development Budget: €250 - €750 EUR
Custom WordPress Site for Increased Sales Category: Content Management System (CMS), Content Writing, Copywriting, Ghostwriting, SEO, Web Development, Web Design, WordPress Budget: ₹750 - ₹1250 INR
