invalid property assignment number

• Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers
• Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand
• OverflowAI GenAI features for Teams
• OverflowAPI Train & fine-tune LLMs
• Labs The future of collective knowledge sharing
• About the company Visit the blog

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Get early access and see previews of new features.

VBA Wrong number of arguments or invalid property assignment

Out of touch with vba and so i am sure its a silly mistake somewhere. Would be really helpful if someone could point that out

• 1 Where do you get the error? What is the desired behavior of that code? Please take time to read this link before editing your post to improve it : stackoverflow.com/help/how-to-ask –  R3uK Commented Nov 19, 2015 at 8:20
• please see stackoverflow.com/questions/2237873/… to understand what is .Height properties –  Fabrizio Commented Nov 19, 2015 at 8:28
• 1 Probably Range(d, C6498) is not valid in this way. You could use e.g. Range("A1:C3") or Range(Cells(...), Cells(...)) . Maybe you wanted Range("C4:C6498") ? –  gembird Commented Nov 19, 2015 at 8:28

First you had an issue of declaring your ranges, C4 as itself in VBA is considered as a variable, you need to use one these :

[C4] or Range("C4") or Cells(4,3) or Cells(4,"C")

So your lines or defining ranges should look like this :

Secondly , the .Height property will give you the size of the range, not the number of rows, to get the number of rows, you need to use Range(...).Rows.Count

Here is your full code :

Your Answer

Reminder: Answers generated by artificial intelligence tools are not allowed on Stack Overflow. Learn more

Sign up or log in

Post as a guest.

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy .

Not the answer you're looking for? Browse other questions tagged vba excel or ask your own question .

• Featured on Meta
• We've made changes to our Terms of Service & Privacy Policy - July 2024
• Bringing clarity to status tag usage on meta sites
• Feedback requested: How do you use tag hover descriptions for curating and do...

Hot Network Questions

• Specify geo location of web pages (each is different)
• shell script to match a function in a file and replace it with another function in another file
• Who is affected by Obscured areas?
• Harmonic, partial, overtone. Which is which?
• bin.usr-is-merged, lib.usr-is-merged, sbin.usr-is-merged - what are the folders?
• Extrude Individual Faces function is not working
• Is math a bad discipline for teaching jobs or is it just me?
• Unreachable statement when upgrading APEX class version
• Löb’s paradox in first-order logic
• How do you "stealth" a relativistic superweapon?
• Sci-fi book with a part-human, part-machine protagonist who lives for centuries to witness robots gain sentience and wage war on humans
• Joined Progression (all possible ones)
• Fourth order BVP partial differential equation
• Advice needed: Team needs developers, but company isn't posting jobs
• Why would an incumbent politician or party need to be re-elected to fulfill a campaign promise?
• Is the oil level here too high that it needs to be drained or can I leave it?
• Implications of the statement: "Note that it is very difficult to remove Rosetta 2 once it is installed"
• are "lie low" and "keep a low profile" interchangeable?
• Does a Way of the Astral Self Monk HAVE to do force damage with Arms of the Astral Self from 10' away, or can it be bludgeoning?
• Easyjet denied EU261 compensation for flight cancellation during Crowdstrike: Any escalation or other recourse?
• ~1980 UK TV: very intelligent children recruited for secret project
• Unexpected behaviour during implicit conversion in C
• Why did R Yochanan say 'We' when he Refuted Reish Lakish on his own?
• Can police offer an “immune interview”?

HatchJS.com

Cracking the Shell of Mystery

Wrong number of arguments or invalid property assignment: how to fix it and prevent it from happening again

Wrong Number of Arguments or Invalid Property Assignment

When you’re programming, it’s important to make sure that you’re using the right number of arguments for your functions and that you’re assigning properties to the correct objects. If you don’t, you’ll get an error message like “wrong number of arguments” or “invalid property assignment.”

This article will discuss what these errors mean and how to fix them. We’ll also provide some tips on how to avoid these errors in the first place.

What do these errors mean?

The “wrong number of arguments” error means that you’ve called a function with the wrong number of arguments. For example, if a function expects two arguments, but you only pass it one, you’ll get this error.

The “invalid property assignment” error means that you’ve tried to assign a property to an object that doesn’t have that property. For example, if you try to assign the `name` property to a number, you’ll get this error.

How to fix these errors

To fix these errors, you need to make sure that you’re using the right number of arguments for your functions and that you’re assigning properties to the correct objects.

Here are a few tips:

• Check the documentation for the function you’re calling to see how many arguments it expects.
• Make sure that you’re passing the correct types of arguments to the function.
• Check the object to make sure that it has the property you’re trying to assign.

How to avoid these errors in the first place

The best way to avoid these errors is to be careful when you’re programming. Here are a few tips:

• Use a linter. A linter is a tool that can help you find errors in your code, including errors with arguments and property assignments.
• Write unit tests. Unit tests can help you catch errors in your code before they cause problems.
• Get feedback from other programmers. Having someone else look over your code can help you find errors that you might have missed.

By following these tips, you can help yourself avoid the “wrong number of arguments” and “invalid property assignment” errors.

| Wrong number of arguments | Invalid property assignment | Example | |—|—|—| | Missing required argument | Using an invalid property name | `document.write(‘Hello World’);` | | Too many arguments | Using a property with the wrong data type | `document.getElementById(‘myElement’).style.backgroundColor = ‘red’;` | | Invalid data type | Using a property with an invalid value | `document.getElementById(‘myElement’).innerHTML = ‘1234567890’;` |

In programming, a wrong number of arguments or invalid property assignment is a type of error that occurs when a function is called with the wrong number of arguments or when a property is assigned to an object with the wrong type. These errors can cause the program to crash or produce incorrect results.

What is a wrong number of arguments?

A wrong number of arguments occurs when a function is called with the wrong number of arguments. For example, a function that expects two arguments might be called with only one argument. This can cause the function to crash or produce incorrect results.

To avoid wrong number of arguments errors, it is important to make sure that you call functions with the correct number of arguments. You can do this by checking the documentation for the function to see how many arguments it expects. You can also use a linter to check your code for errors.

What is an invalid property assignment?

An invalid property assignment occurs when a property is assigned to an object with the wrong type. For example, a string might be assigned to a property that expects a number. This can cause the program to crash or produce incorrect results.

To avoid invalid property assignment errors, it is important to make sure that you assign properties to objects with the correct type. You can do this by checking the documentation for the object to see what types of properties it supports. You can also use a linter to check your code for errors.

Causes of wrong number of arguments or invalid property assignment

The most common cause of wrong number of arguments or invalid property assignment errors is incorrect code. This can happen when a developer forgets to add an argument to a function call, or when they assign a property to an object with the wrong type.

Compiler errors can also cause wrong number of arguments or invalid property assignment errors. For example, if a function is declared with the wrong number of arguments, the compiler will generate an error.

How to fix wrong number of arguments or invalid property assignment errors

To fix wrong number of arguments or invalid property assignment errors, you need to find the source of the error and correct it. This may involve adding or removing arguments from a function call, or assigning properties to objects with the correct type.

You can use a debugger to help you find the source of the error. A debugger allows you to step through your code line by line, and it can help you identify errors that are difficult to spot.

Wrong number of arguments or invalid property assignment errors can be a frustrating problem, but they can be fixed by finding the source of the error and correcting it. By following the tips in this article, you can avoid these errors and keep your code running smoothly.

Additional information

In addition to the causes listed above, there are a few other things that can cause wrong number of arguments or invalid property assignment errors. These include:

• Type errors: A type error occurs when a variable is assigned a value of the wrong type. For example, assigning a string to a variable that expects a number is a type error.
• Casting errors: A casting error occurs when a value is converted to the wrong type. For example, trying to convert a string to a number is a casting error.
• Reference errors: A reference error occurs when a variable does not refer to a valid object. For example, trying to access a property of a variable that does not exist is a reference error.

If you are experiencing wrong number of arguments or invalid property assignment errors, it is important to understand the cause of the error so that you can fix it. By following the tips in this article, you can avoid these errors and keep your code running smoothly.

What are the consequences of wrong number of arguments or invalid property assignment?

Wrong number of arguments or invalid property assignment can have a number of consequences, including:

• Errors: Wrong number of arguments or invalid property assignment can cause errors to occur. These errors can range from simple syntax errors to more serious runtime errors.
• Data corruption: Wrong number of arguments or invalid property assignment can also lead to data corruption. This can happen when a property is assigned to an object with the wrong type, or when a function is called with the wrong number of arguments.
• Security vulnerabilities: Wrong number of arguments or invalid property assignment can also create security vulnerabilities. This can happen when a function is called with the wrong number of arguments, allowing an attacker to bypass security checks.

How to avoid wrong number of arguments or invalid property assignment?

There are a number of things you can do to avoid wrong number of arguments or invalid property assignment, including:

• Write unit tests: Unit tests can help you to identify and fix errors in your code. Unit tests can be used to verify that functions are called with the correct number of arguments, and that properties are assigned to objects with the correct type.
• Use a linter: A linter can help you to identify potential errors in your code. Linters can be used to check for incorrect code that could lead to wrong number of arguments or invalid property assignment errors.
• Read the documentation: The documentation for your programming language and libraries can provide you with information on how to use functions and assign properties to objects correctly.

In addition, you can also follow these general tips to avoid wrong number of arguments or invalid property assignment:

• Be careful when calling functions: Make sure that you are calling functions with the correct number of arguments. If you are not sure, check the documentation for the function.
• Use type annotations: Type annotations can help you to catch errors in your code. When you use type annotations, the compiler will check to make sure that you are assigning properties to objects with the correct type.
• Be careful when using dynamic typing: Dynamic typing allows you to assign properties to objects with different types. However, this can also lead to errors if you are not careful. When using dynamic typing, make sure that you are aware of the type of the object that you are assigning a property to.

Wrong number of arguments or invalid property assignment can have a number of consequences, including errors, data corruption, and security vulnerabilities. There are a number of things you can do to avoid these errors, including writing unit tests, using a linter, reading the documentation, and being careful when calling functions and assigning properties to objects.

Q: What does it mean when I get an error message that says “wrong number of arguments or invalid property assignment”?

A: This error message indicates that you have either provided the wrong number of arguments to a function, or you have assigned a value to a property that does not exist.

Q: How can I fix this error?

A: To fix this error, you will need to check the documentation for the function or property that you are trying to use. Make sure that you are providing the correct number of arguments, and that you are assigning values to valid properties.

Q: What are some common examples of this error?

A: Some common examples of this error include:

• Trying to call a function with the wrong number of arguments, such as `myFunction(1)` when the function expects two arguments.
• Trying to assign a value to a property that does not exist, such as `myObject.myProperty = ‘value’` when the object does not have a property called `myProperty`.

Q: What can I do to prevent this error from happening in the future?

A: To prevent this error from happening in the future, you can:

• Carefully read the documentation for the functions and properties that you are using.
• Make sure that you are providing the correct number of arguments to functions, and that you are assigning values to valid properties.
• Use a linter to check your code for errors.

Q: Is there anything else I should know about this error?

A: Yes, there are a few other things you should know about this error:

• This error can occur in any programming language.
• This error can be difficult to debug, especially if you are not familiar with the function or property that you are trying to use.

We hope that this article has been helpful. If you have any other questions about this error, please feel free to contact us.

Here are some key takeaways from this article:

• The wrong number of arguments or invalid property assignment error occurs when you pass the wrong number of arguments to a function or when you assign a value to a property that does not exist.
• Some common causes of this error include typos, forgetting to add parentheses around an argument list, and trying to access a property that does not exist.
• To fix this error, check your code carefully and make sure that you are passing the correct number of arguments to functions and that you are assigning values to valid properties.

Author Profile

Latest entries

• December 26, 2023 Error Fixing User: Anonymous is not authorized to perform: execute-api:invoke on resource: How to fix this error
• December 26, 2023 How To Guides Valid Intents Must Be Provided for the Client: Why It’s Important and How to Do It
• December 26, 2023 Error Fixing How to Fix the The Root Filesystem Requires a Manual fsck Error
• December 26, 2023 Troubleshooting How to Fix the `sed unterminated s` Command

Similar Posts

React rctbridgedelegate.h file not found: how to fix.

React RCTBridgeDelegate.h File Not Found: A Guide to Fixing the Error If you’re a React developer, you’ve probably come across the dreaded “RCTBridgeDelegate.h file not found” error. This error can be a real pain, as it can prevent you from running your React app. In this guide, we’ll walk you through how to fix the…

Windows Photo Viewer Can’t Display This Picture: Not Enough Memory (Fix)

Windows Photo Viewer Can’t Display This Picture: Not Enough Memory Have you ever tried to open a picture in Windows Photo Viewer, only to be met with the error message “Windows Photo Viewer can’t display this picture because there isn’t enough memory”? If so, you’re not alone. This is a common problem that can be…

YouTube Videos with Green Lines: What They Are and How to Fix Them

Have you ever seen those green lines on YouTube videos? They’re called “chroma key lines,” and they’re used to create special effects by removing the background from a video. This can be done in a variety of ways, but the most common is to use a green screen. A green screen is a large piece…

Expo Command Not Found: How to Fix

Expo: A Framework for Building Cross-Platform Mobile Apps Expo is a framework that makes it easy to build cross-platform mobile apps. With Expo, you can write your app in React Native and deploy it to Android, iOS, and the web with a single command. Expo is a great option for developers who want to build…

Invalid object name ‘string_split’: How to fix it

Invalid Object Name String_split Have you ever tried to use the `string_split` function in Python and gotten an error message like `invalid object name string_split`? If so, you’re not alone. This is a common error that can be caused by a number of things. In this article, we’ll take a look at what causes the…

Invalid Subscript Type ‘List’: What It Is and How to Fix It

Have you ever tried to use a subscript in Python, only to get an error message like “invalid subscript type ‘list’”? If so, you’re not alone. This is a common error that can be caused by a number of things. In this article, we’ll take a look at what causes this error and how to…

How To Fix “Invalid Property Assignment (Error 450)”

If you are testing the return value of a function in the immediate window in VBA and get the following error:

Wrong number of arguments or invalid property assignment (Error 450)

What you are doing is something like this:

Then in the immediate window typing:

The code appears to work fine, but the error is a mystery. The reason for the error is that the immediate window call expects a collection, but isn’t receiving one.

Therefore, to properly test your functions returning a collection data type create a test subroutine that calls the function and receives the collection returned. Such as:

Then in the immediate window enter the name of the subroutine just created:

You should then see the following output:

When testing functions that return a Collection data type instead of using the immediate window defer instead to calling them from a test subroutine. Then output the desired response to visually check your code works, or instead of printing to the immediate window, use Debug.Assert like this:

If there’s a problem with your function when the subroutine is ran in the immediate window it will break at the failed assertion test.

Either way, learning this has helped brush up my rusty Excel VBA skills as I jump back into Excel VBA 2016.

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Wrong number of arguments or property assignment not valid

• 8 contributors

An assignment has been attempted that is not valid.

To correct this error

Check that the number of arguments you have supplied matches the number required by the target.

Check the property assignment.

• Assignment Operators

Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback .

Submit and view feedback for

Additional resources

• Search forums
• Board Rules

Follow along with the video below to see how to install our site as a web app on your home screen.

Note: This feature may not be available in some browsers.

• If you would like to post, please check out the MrExcel Message Board FAQ and register here . If you forgot your password, you can reset your password .
• Question Forums
• Excel Questions

Error in VBA(wrong number of arguments or invalid property assignment)

• Thread starter JiangSH
• Start date Dec 13, 2021
• Tags debug error error vba
• Dec 13, 2021

hi everyone! I was doing some exercise about Function in VBA when an error occurred(wrong number of arguments or invalid property assignment).Here is the picture. Really needs your help !! thx!!  

Attachments

Excel Facts

Well-known member.

• Dec 14, 2021

What is the easiest way to take two columns of data and convert to dictionary?

MrExcel MVP, Moderator

Welcome to the MrExcel board! When asking questions about a particular code please post the actual code, not a picture of it. My signature block below has more help on how to do that. Also, if asking about an error, as well as giving the error message, tell us which line of code caused the error.  

A bit troublesome since code is short ? . I'm just guessing your problem here. This is not way to add data to Dictionary The Dict(KeyColumn(i, 1)) = ValueColumn(i, 1) should be Dict.Add KeyColumn(i, 1), ValueColumn(i, 1) However, your column has no range limit. When KeyColumn(i, 1) becomes rows of zero or blank, then you will have error.  

Zot said: This is not way to add data to Dictionary The Dict(KeyColumn(i, 1)) = ValueColumn(i, 1) Click to expand...

Peter_SSs said: Dict(SomeKeyValue) = SomeItemValue .. is a perfectly valid way to add an entry to a Dictionary. One thing that I noticed about the code is that "Key" and "Value" are used as variable arguments for the function and it is a very bad idea to use words as variables that vba already has special meanings for. There could also be an issue with the type of double quote marks used. Click to expand...

Zot said: Here is what I converted Click to expand...

It is not entirely clear what the OP is wanting to achieve, but this is my estimate. VBA Code: Sub test1() Dim dictl As Variant dictl = CreateDictForTwoColumns("a", "b") End Sub Function CreateDictForTwoColumns(sKey As String, sValue As String) Dim KeyColumn As Variant, ValueColumn As Variant Dim Dict As Object Dim i As Long Set Dict = CreateObject("scripting.dictionary") KeyColumn = ThisWorkbook.Worksheets(1).Range(sKey + ":" + sKey) ValueColumn = ThisWorkbook.Worksheets(1).Range(sValue + ":" + sValue) For i = 1 To UBound(KeyColumn, 1) Dict(KeyColumn(i, 1)) = ValueColumn(i, 1) Next CreateDictForTwoColumns = Array(Dict.Keys, Dict.Items) End Function  

Peter_SSs said: It is not entirely clear what the OP is wanting to achieve, but this is my estimate. VBA Code: Sub test1() Dim dictl As Variant dictl = CreateDictForTwoColumns("a", "b") End Sub Function CreateDictForTwoColumns(sKey As String, sValue As String) Dim KeyColumn As Variant, ValueColumn As Variant Dim Dict As Object Dim i As Long Set Dict = CreateObject("scripting.dictionary") KeyColumn = ThisWorkbook.Worksheets(1).Range(sKey + ":" + sKey) ValueColumn = ThisWorkbook.Worksheets(1).Range(sValue + ":" + sValue) For i = 1 To UBound(KeyColumn, 1) Dict(KeyColumn(i, 1)) = ValueColumn(i, 1) Next CreateDictForTwoColumns = Array(Dict.Keys, Dict.Items) End Function Click to expand...

Peter_SSs said: Welcome to the MrExcel board! When asking questions about a particular code please post the actual code, not a picture of it. My signature block below has more help on how to do that. Also, if asking about an error, as well as giving the error message, tell us which line of code caused the error. Click to expand...

Similar threads

• Mar 12, 2024
• Patriot2879
• Jun 18, 2024
• Apr 10, 2024
• Jul 27, 2024

• Oct 21, 2023

Forum statistics

Share this page.

We've detected that you are using an adblocker.

Which adblocker are you using.

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock

• Forgotten Your Password?

• Today's Posts
• Mark Forums Read
• Quick Links :
• What's New?
• Members List

Forum Rules

• Commercial Services
• Advanced Search

• Microsoft Office Application Help - Excel Help forum
• Excel Programming / VBA / Macros
• [SOLVED] VBA - Compile Error - Wrong number of arguments

VBA - Compile Error - Wrong number of arguments

Thread tools.

• Show Printable Version
• Subscribe to this Thread…

Rate This Thread

• Current Rating
• ‎ Excellent
• ‎ Average
• ‎ Terrible
• Linear Mode
• Switch to Hybrid Mode
• Switch to Threaded Mode

Hi Guys I have created a UserForm to add data to which is working fine. I have added a search button to search for the data and pull it back to the UserForm I have created but am getting the following error --------------------------- Microsoft Visual Basic --------------------------- Compile error: Wrong number of arguments or invalid property assignment --------------------------- OK Help --------------------------- Please find below the code I have so far Please Login or Register to view this content. new Clipboard(".copy2clipboard",{target:function(a){for(;a ? a.getAttribute?a.getAttribute?!/bbcode_description/.test(a.getAttribute("class")):null:null:null;)a=a.parentNode;for(var b=a.nextElementSibling;b?!b.classList.contains("bbcode_code"):null;)b=b.nextElementSibling;return b}}); Thanks for your help

Re: VBA - Compile Error - Wrong number of arguments

Where do you get the error?

If posting code please use code tags, see here .

I suspect that is your message boxes: Please Login or Register to view this content. new Clipboard(".copy2clipboard",{target:function(a){for(;a ? a.getAttribute?a.getAttribute?!/bbcode_description/.test(a.getAttribute("class")):null:null:null;)a=a.parentNode;for(var b=a.nextElementSibling;b?!b.classList.contains("bbcode_code"):null;)b=b.nextElementSibling;return b}}); Lose some brackets: Please Login or Register to view this content. new Clipboard(".copy2clipboard",{target:function(a){for(;a ? a.getAttribute?a.getAttribute?!/bbcode_description/.test(a.getAttribute("class")):null:null:null;)a=a.parentNode;for(var b=a.nextElementSibling;b?!b.classList.contains("bbcode_code"):null;)b=b.nextElementSibling;return b}}); Check if there are any others. Regards, TMS

Trevor Shuttleworth - Retired Excel/VBA Consultant I dream of a better world where chickens can cross the road without having their motives questioned 'Being unapologetic means never having to say you're sorry' John Cooper Clarke

Hi Getting the message around Please Login or Register to view this content. new Clipboard(".copy2clipboard",{target:function(a){for(;a ? a.getAttribute?a.getAttribute?!/bbcode_description/.test(a.getAttribute("class")):null:null:null;)a=a.parentNode;for(var b=a.nextElementSibling;b?!b.classList.contains("bbcode_code"):null;)b=b.nextElementSibling;return b}});

You've one too many arguments, you are using x 1 instead of x l and some of the arguments are out of place. If you only want to specify certain arguments use there names. I think it should be something like this but you'd better check. Please Login or Register to view this content. new Clipboard(".copy2clipboard",{target:function(a){for(;a ? a.getAttribute?a.getAttribute?!/bbcode_description/.test(a.getAttribute("class")):null:null:null;)a=a.parentNode;for(var b=a.nextElementSibling;b?!b.classList.contains("bbcode_code"):null;)b=b.nextElementSibling;return b}}); PS You should probably check the MsgBox code too as TMShucks suggested, that was actually my first thought on where the problem was.

Looks like find takes 9 parameters. You have 10. http://msdn.microsoft.com/en-us/libr.../ff839746.aspx expression .Find(What, After, LookIn, LookAt, SearchOrder, SearchDirection, MatchCase, MatchByte, SearchFormat) Regards, TMS

Thanks Guys Getting a Runtime error 424 line highlighted in Yellow is Please Login or Register to view this content. new Clipboard(".copy2clipboard",{target:function(a){for(;a ? a.getAttribute?a.getAttribute?!/bbcode_description/.test(a.getAttribute("class")):null:null:null;)a=a.parentNode;for(var b=a.nextElementSibling;b?!b.classList.contains("bbcode_code"):null;)b=b.nextElementSibling;return b}});

Please find Sample workbook maybe easier to resolve Issue I want to search by CRN number and it pulls all the other information back to Userform excluding the Timestamp

Last edited by Janto724; 06-27-2013 at 11:20 AM .

What's in TextBox1?

There isn't a control called Textbox1. You have txtHouse, txtCRN etc for your textboxes on the userform. So I suppose the line should be this. Please Login or Register to view this content. new Clipboard(".copy2clipboard",{target:function(a){for(;a ? a.getAttribute?a.getAttribute?!/bbcode_description/.test(a.getAttribute("class")):null:null:null;)a=a.parentNode;for(var b=a.nextElementSibling;b?!b.classList.contains("bbcode_code"):null;)b=b.nextElementSibling;return b}});

Hello Janto724, I made some modifications to your workbook. The results are now displayed in a ListBox. Have a look and let me know what you think about the changes.

Sincerely, Leith Ross Remember To Do the Following... . 1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code. 2. Thank those who have helped you by clicking the Star below the post. 3. Please mark your post [SOLVED] if it has been answered satisfactorily . Old Scottish Proverb... Luathaid gu deanamh maille! (Rushing causes delays!)

Hi Leith Thanks for your help and amendments to the code Works great

Can I just check? Were the suggestions I made of any use?

Hi Norie The suggest you made were of use it looks as though when I created the user form I needed to add description box for all the inforamtion to feedback into. I would have preferred the data to fall back into each individual text box.

Sorry, you've kind of lost me there. As far as I can see there was nothing wrong with the userform, the code just needed a few tweaks.

Thread Information

Users browsing this thread.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
• BB code is On
• Smilies are On
• [IMG] code is Off
• HTML code is Off
• Trackbacks are Off
• Pingbacks are Off
• Refbacks are Off
• ExcelForum.com