Hide/Unhide text box based on cell value with real-time data from arduino

[art_a_game]

Hi! I need some help. I have a column in sheet 1 that have a real time data on it that comes from arduino and I want to hide or unhide a textbox on sheet2 based on the value of the cells in the column but everytime the arduino feed data to the cell nothing happens but when I manually enter data the textbox can now be hide/unhide. Please help! Here is my code:

Please Login or Register  to view this content.

[karedog]

You are comparing the Target's value with "40" (40 as string datatype), which means :
6 <= "40" --> True
"6" <= "40" --> False

So if your arduino set data on column B as string, you probably want to change the event sub to something like this :

Please Login or Register  to view this content.

[art_a_game]

Hi! Thanks for the reply! My arduino data is set as float but i'll try this out! By the way my arduino data appears in column b of sheet 1 but my textbox is in sheet 2.

[karedog]

You are welcome.

If the changes is on sheet1, then the event sub must be placed on sheet1 also, or it will not be triggered, so put this code on sheet1 (not sheet2) :

Please Login or Register  to view this content.

[art_a_game]

It works! Super Thank You!!!!

[karedog]

You are welcome.

Don't forget to mark this thread as solved :
select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[art_a_game]

I tried entering the values manually and it works but when I tried the arduino data the textbox is not hiding. What I observe is that everytime I press enter, the code applies but when i doesn't hit enter the code doesn't applies.

[karedog]

It means that arduino sending the data without carriage return ending. You must modify your arduino side (not Excel side) code.
From a quick googling, you may want to use println() instead of print() or write(), or if you use print() or write() you must manually adding the carriage return :
https://www.arduino.cc/en/Serial/Println
http://forum.arduino.cc/index.php?topic=144434.0

[art_a_game]

I have my println but still isn't working

[karedog]

Then you must ask this (not sending carriage return) on arduino forum. From Excel (vba) side, the code is already good. The last missing point is howto adding/sending carriage return to the data that you send.

[art_a_game]

My data is already in carriage return. I also tried put a lookup formula in cell "E2" for column B and change the code to:

Please Login or Register  to view this content.

Still it isn't working i am thinking that it is really with the enter factor.

[art_a_game]

By the way karedog thank you again for helping me.

[karedog]

You are welcome. I can't help you further because I don't have any arduino hardware. You can also try to add linefeed after carriage return (chr(13) chr(10)) as mentioned in one of the links on post #8. You better to ask this on one of arduino forum, since the problem is related to arduino side. Once you success simulating "pressing enter", the vba code is already good to run. As a note, your current arduino code is only sending "some characters" to Excel without "pressing Enter", this will make Excel is still in "Edit mode" (like when you pressing F2 on a cell and typing but hasn't press Enter or click on other cell yet), and this will not trigger the event sub.