help with code

[suedavies123]

hi, can anyone see anything obvious with the VBA code below. I have set up 3 work sheets all with 2 command buttons (test & retest) only sheet three with the addition of a list box. am I over thinking or am I being stupid? it just wont work or connect with command buttons....I would appreciate some help. sorry its a bit long!

Please Login or Register  to view this content.

[/CODE][/CODE][/CODE][/CODE][/CODE]

[JLGWhiz]

Yes, it does not have code tags. Click the 'Edit Post' button, then use the mouse pointer to higlight all of your code. Then click the pound symbol (#) in the tool bar of the edit pane. Code tags will then be put on you code and it will hold its format when you click the 'Post Reply' button. In the meantime, I will be looking at the code you posted to see if I can help.

If IsEmpty(Range("D5")) Then

This is an incorrect use of the IsEmpty function and can result is erroneous results. Use this syntax instead:

Please Login or Register  to view this content.

The IsEmpty function in VBA is designed to test if a variable has been initialized. Its properties do not include the value of a cell, so it can return a false result if used to check whether a cell is blank or not.

In VBA3

If fib.ListBox <> -1 Then

I am not sure what the fib is but the syntax appears to be the problem. Let's say that the listbox name is List Box 1 and it is from the Form Controls tool box. The syntax would be like this

Please Login or Register  to view this content.

. If fib is not a global variable, it needs to be declared within the macro.

these are a couple of things I noticed.

[suedavies123]

Thank you, I will change and see if it works and will let you know. I'm wondering if it's because of that why it wont connect.

[protonLeah]

1. Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 6)
2. Your post does not comply with Rule 2 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.

Click on Edit to open your thread, then 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 6)

[JLGWhiz]

If you do not use the correct syntax for the name of the control, it vba will either throw an error or ignore it. One way to see what is happening is to step through the code useing the F8 funcion key. To do that, open the vb editor pane (Alt + F11) to your code, click anywhere in the body of the code then press F8 key. The title line of the code should highlight in yellow. Then as you press F8, the highlight moves to the next line of code with the previous line being excuted. You can diminishe the size of the editor window so it overlays the worksheet window and see what is happening as the code executes. If the highlight changes on the code but the worksheet does not reflect that change then you know where to look for the cause of the problem.

[AliGW]

Not only is the thread title (still) not suitable, you have cross-posted here: https://www.mrexcel.com/forum/excel-...-vba-code.html

You are a new member and will be given the benefit of the doubt, therefore, but please make sure you read and adhere to our forum rules in future: https://www.excelforum.com/forum-rul...rum-rules.html

[suedavies123]

please feel free to remove me. I thought you could come to these sites for help. I received an email saying I wouldn't get any responses until i had done something that I couldn't work out how to do, so I went somewhere else for help and have now had an email from them saying I wont receive and responses because I have cross posted.... so please remove me.

[alansidman]

@suedavies123
It is a simple case of, please read the forum rules and abide by them and we will be more than happy to assist you. It is apparent from your post that you have ignored our requests to read and abide by our rules. Help is available once you do so.

[suedavies123]

So I keep being told. God forbid a new member makes a mistake. Please tell me how to remove my account.