Declaring Strings

Hi All

I'm fairly new to VBA, but have written some code so that when a checkbox is ticked an inputbox appears, forces a user to enter data, then that input data goes into a specific cell. everything worked fine on my first one. when I try to duplicate the same thing for a different checkbox, a different inputbox and different specific cell I get an error that says
Compile error: Duplicate declaration in current scope.

This is my code for the one that works;

Please Login or Register  to view this content.

[/I]and this is the code for the one that doesn't;

Please Login or Register  to view this content.

Please help....many thanks

WallFinish is the name of an object already declared, a checkbox or something. I can tell because it has a _Click event which you are coding into. Use a different variable name, sWallFinish or strWallFinish.



Duplicates:-

Please Login or Register  to view this content.

babb101,
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)