klemeeri
12-06-2012, 06:43 AM
I have a column of numbers, taken from a device at a set frequency (ranging from 50ms to 100ms).
Values range from -500 to +500.
Depending on how long I measure, I could have a few thousand val's in the column.
I am not sharp on VBA stuff... so I need idiot proof help.
I want to draw 2 buttons on the worksheet, assign a macro to START playing and another to STOP or "break" the execution.
As for the sound....I want to hear the different values in a way that sounds like a theremin or light saber deal. The "theremin" is the instrument from the Beach Boys song....
Not sure if there's a way to change the pitch of a single note (based on scaling the value) or whether I just need a lookup table with 100 different tones and use the value to drive which tone is played.
Any help is appreciated. Thanks
Values range from -500 to +500.
Depending on how long I measure, I could have a few thousand val's in the column.
I am not sharp on VBA stuff... so I need idiot proof help.
I want to draw 2 buttons on the worksheet, assign a macro to START playing and another to STOP or "break" the execution.
As for the sound....I want to hear the different values in a way that sounds like a theremin or light saber deal. The "theremin" is the instrument from the Beach Boys song....
Not sure if there's a way to change the pitch of a single note (based on scaling the value) or whether I just need a lookup table with 100 different tones and use the value to drive which tone is played.
Any help is appreciated. Thanks