1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 02-Feb-2026 17:39 GMT
View Project
View this project in detail (Note: you will be redirected to external marketplace)
Project title: I need help with one simple bit of VBA code.
Posted by: External project from PeoplePerHour
Started: 10-Apr-2025 04:46 GMT
Description: 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

Me.TextBoxInstall.Value = "£" & installValue & " - £" & (installValue + 100)

UpdateTextBox300
End If
End Sub
Project ID: 3429191
Project category:
Project budget:
View this project in detail (Note: you will be redirected to external marketplace)
Last Projects / Browse Projects
  Project Started
Social Media Verification & Wikipedia Page Creation for Video Producer
Category: Facebook Marketing, Internet Marketing, Marketing, Social Media Marketing, Twitter
Budget: ₹12500 - ₹25000 INR
02-Feb-2026
21:40 GMT
Beauceron Database Development
Category: Data Management, Database Development, Database Management, Database Programming, MySQL, PHP, UI / User Interface, User Experience Research
Budget: $750 - $1500 USD
02-Feb-2026
17:04 GMT
Excel to XML for SEC EDGAR - 02/02/2026 12:03 EST
Category: Data Analysis, Data Entry, Data Management, Data Processing, Excel, JSON, Visual Basic, XML
Budget: $30 - $250 USD
02-Feb-2026
17:04 GMT
Oracle SQL Developer (Female Candidate Preferred)
Category: Database Administration, Database Development, MySQL, Oracle, SQL
Budget: £25000 - £50000 GBP
02-Feb-2026
17:03 GMT
Instagram & TikTok Content Creation
Category: After Effects, Animation, Content Creation, Instagram, Photography, Social Media Marketing, Video Editing, Videography
Budget: $10 - $25 USD
02-Feb-2026
17:02 GMT
Python S3 Connection adjustment & Polars Data Utility
Category: Coding, Database Management, Flask, JavaScript, Open Source, Python, Software Development
Budget: $10 - $30 USD
02-Feb-2026
17:01 GMT
3D Anamorphic Steel Video Creation
Category: 3D Animation, 3D Design, 3D Graphic Design, 3D Illustration, 3D Modelling, 3D Rendering, 3D Visualization, Animation, Video Post Editing, Visual Effects
Budget: ₹37500 - ₹75000 INR
02-Feb-2026
17:01 GMT
Need Vibe Social Media Management Help
Category: Content Creation, Content Writing, Data Analysis, Facebook Marketing, Instagram Marketing, Social Media Management, Social Media Marketing, Twitter
Budget: €30 - €250 EUR
02-Feb-2026
17:01 GMT
Sales-Focused Shopify Store Design
Category: ECommerce, Graphic Design, HTML, SEO, Shopify, Shopify Development, Web Design
Budget: ₹1500 - ₹12500 INR
02-Feb-2026
17:00 GMT
Salesforce Architect
Category: REST API, Salesforce CPQ, Salesforce Lightning, Salesforce Marketing Cloud, Salesforce.com
Budget: $8 - $15 USD
02-Feb-2026
16:59 GMT
Ultra-Detailed Sci-Fi Truck Model
Category: 3D Animation, 3D Design, 3D Graphic Design, 3D Modelling, 3D Rendering, 3D Visualization, 3ds Max, Game Development
Budget: $30 - $250 USD
02-Feb-2026
16:59 GMT
إعادة رسم مخطوطة عربية من صورة وتحويلها إلى Vector (AI)
Category: Adobe Illustrator, Photoshop, Illustration, Vector Design
Budget: $10 - $30 USD
02-Feb-2026
16:59 GMT
AutoCAD Package Vending Machine Drawing
Category: 2D Drafting, 3D CAD, 3D Design, 3D Modelling, AutoCAD, CAD / CAM, Drafting, Mechanical Engineering, Product Design, Solidworks
Budget: €30 - €250 EUR
02-Feb-2026
16:58 GMT
Exceptional Interior & Exterior Design Services
Category: 3D Design, 3D Modelling, 3D Rendering, 3D Studio Max, Building Design, Content Writing, Exterior Design, Graphic Design, Interior Design, Photoshop
Budget: ₹600 - ₹1500 INR
02-Feb-2026
16:58 GMT
Identify Fake Instagram Email
Category: Data Mining, Data Protection, Digital Forensics, Instagram API, Internet Research, Network Security
Budget: ₹600 - ₹1500 INR
02-Feb-2026
16:58 GMT
Browse All Projects
Projects by Skills ...
Projects for 'android'
Projects for 'ajax'
Projects for 'asp'
Projects for 'aspnet'
Projects for 'cms'
Projects for 'cpp'
Projects for 'csharp'
Projects for 'css'
Projects for 'delphi'
Projects for 'design'
Projects for 'drupal'
Projects for 'excel'
Projects for 'facebook'
Projects for 'flash'
Projects for 'html'
Projects for 'java'
Projects for 'javascript'
Projects for 'joomla'
Projects for 'iphone'
Projects for 'mysql'
Projects for 'photoshop'
Projects for 'php'
Projects for 'python'
Projects for 'ruby'
Projects for 'seo'
Projects for 'sql'
Projects for 'sysadm'
Projects for 'translate'
Projects for 'typing'
Projects for 'twitter'
Projects for 'vbnet'
Projects for 'xml'
Projects for 'wordpress'
Projects for 'writing'
Read RSS feeds ... New!
RSS feed for 'android'
RSS feed for 'ajax'
RSS feed for 'asp'
RSS feed for 'aspnet'
RSS feed for 'cms'
RSS feed for 'cpp'
RSS feed for 'csharp'
RSS feed for 'css'
RSS feed for 'delphi'
RSS feed for 'design'
RSS feed for 'drupal'
RSS feed for 'excel'
RSS feed for 'facebook'
RSS feed for 'flash'
RSS feed for 'html'
RSS feed for 'java'
RSS feed for 'javascript'
RSS feed for 'joomla'
RSS feed for 'iphone'
RSS feed for 'mysql'
RSS feed for 'photoshop'
RSS feed for 'php'
RSS feed for 'python'
RSS feed for 'ruby'
RSS feed for 'seo'
RSS feed for 'sql'
RSS feed for 'sysadm'
RSS feed for 'translate'
RSS feed for 'typing'
RSS feed for 'twitter'
RSS feed for 'vbnet'
RSS feed for 'xml'
RSS feed for 'wordpress'
RSS feed for 'writing'
New!
Проекты на русском
(Projects in Russian)

Short URL:
1001fp.com
Mobile version:
m.1001freelanceprojects.com
Copyright © 2005-2025 1001 Freelance Projects