1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 09-Dec-2025 09:48 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
Administrative Building Exterior Renders
Category: 3D Architecture, 3D Modelling, 3D Rendering, 3D Visualization, 3ds Max, Blender, Lumion, SketchUp, V Ray
Budget: ₹3000 - ₹4000 INR
09-Dec-2025
05:02 GMT
Pre-Employment Vetting Project in Nouakchott - Mauritania
Category: Admin Support, Communications, Data Entry, Phone Support
Budget: $10 - $12 USD
09-Dec-2025
05:01 GMT
Refining WordPress Site For U.S. Tax Firm
Category: HTML, SEO, Web Design, Website Management, Website Optimization, Website Testing, WordPress, WordPress Plugin
Budget: $750 - $1500 USD
09-Dec-2025
04:57 GMT
Is this for internet
Category: Article Rewriting, Article Writing, Blog Writing, Content Writing, Copywriting, Ghostwriting, Proofreading, Research, SEO Writing, Technical Writing
Budget: ₹750 - ₹1250 INR
09-Dec-2025
04:56 GMT
Capital Research & Outreach Admin Needed
Category: ChatGPT, CRM, Data Entry, Data Management, Email Marketing, Excel, Lead Generation, Research, Web Search
Budget: $8 - $20 USD
09-Dec-2025
04:56 GMT
I need help with Bubble.io Native App - Tinder Like Dating App (User Photo Management)
Category: Android, App Design, App Development, Bubble Developer, IPhone, Mobile App Development, Mobile Development, PHP, User Experience Research, User Interface / IA
Budget: $10 - $30 USD
09-Dec-2025
04:55 GMT
Homepage Organic Traffic SEO Boost
Category: Analytics, Content Strategy, Internet Marketing, Keyword Research, Link Building, Search Engine Marketing (SEM), SEMrush, SEO
Budget: ₹600 - ₹1500 INR
09-Dec-2025
04:53 GMT
Elegant Minimalist Kids Spa Logo
Category: Adobe Illustrator, Photoshop, Banner Design, Branding, Graphic Design, Logo Design, Market Research, Packaging Design, Vector Design
Budget: $8 - $15 AUD
09-Dec-2025
04:52 GMT
Independent Investigative Journalist – Fraud, Greed, and High-Stakes Human Stories (Remote)
Category: Article Rewriting, Article Writing, Content Writing, Investigation, Investigative Journalism, Journalism
Budget: $250 - $750 USD
09-Dec-2025
04:52 GMT
HealthTrust NEMT Brand Commercial Creation
Category: After Effects, Animation, Color Grading, Video Editing, Video Post Editing, Video Production
Budget: $10 - $30 USD
09-Dec-2025
04:52 GMT
Open Journal System Upgrade
Category: Open Journal Systems, PHP
Budget: $250 - $750 USD
09-Dec-2025
04:51 GMT
STM32 Firmware Development
Category: Controller Area Network (CAN), Debugging, Electrical Engineering, Electronics, Embedded Systems, I2C, Microcontroller, Software Development, STM32, Testing / QA
Budget: ₹1500 - ₹12500 INR
09-Dec-2025
04:49 GMT
Sales & Lead Generation Executive (Commission-Only) | Trustiv
Category: Communications, Lead Generation, Marketing, Sales
Budget: ₹600 - ₹1500 INR
09-Dec-2025
04:47 GMT
ミニシアター正面パース作成
Category: 3D Architecture, 3D Design, 3D Rendering, 3D Visualization, Architectural Rendering, Architectural Visualization, AutoCAD, Graphic Design, Illustration, Interior Design
Budget: $50 - $80 USD
09-Dec-2025
04:46 GMT
Dynamic Instagram Reel Editing -- 2
Category: Adobe Premiere Pro, After Effects, Color Grading, Motion Graphics, Social Media Marketing, Video Editing, Video Production, Video Services
Budget: ₹600 - ₹1500 INR
09-Dec-2025
04:45 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-2024 1001 Freelance Projects