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
Modern Hotel Booking Website Development Category: CSS, Graphic Design, HTML, JavaScript, Payment Gateway Integration, PHP, Web Development, Web Design Budget: $250 - $750 USD
Lead $200K/Month Google & Facebook Ads Category: Advertising, B2B Marketing, Facebook Ads, Facebook Marketing, Google Ads, Internet Marketing, Marketing, Social Media Marketing Budget: $30 - $250 USD
09-Jul-2025 04:02 GMT
2D logo smart -- 2 Category: Graphic Design, Illustration, Logo Design, Photoshop Budget: $15 - $25 USD
09-Jul-2025 04:02 GMT
PHP Web App Content Integration Category: CSS, Graphic Design, HTML, JavaScript, Web Application, Web Development Budget: $15 - $25 USD
09-Jul-2025 04:01 GMT
Modern Company Letterhead Design Category: Adobe Illustrator, Photoshop, Branding, Graphic Design, Illustration, Logo Design, Stationery Design Budget: ₹600 - ₹1500 INR
09-Jul-2025 04:01 GMT
WordPress UI/UX Enhancement Category: Graphic Design, UI / User Interface, User Interface / IA, UX / User Experience, Web Design, Web Development, WordPress Budget: ₹12500 - ₹37500 INR
Local Brand Awareness Campaign Category: Advertising, Facebook Marketing, Internet Marketing, Marketing, Social Media Marketing Budget: $10 - $30 USD
09-Jul-2025 03:55 GMT
Online Travel Booking Platform Development Category: API Integration, Backend Development, Content Management System (CMS), Frontend Development, SEO, Web Development Budget: $30 - $250 USD
