I have a named table called TEXT2ASCIIHEX consisting of the following letters and their ASCII (hex) codes:
I have a spreadsheet with the following words in cells A1,B1,C1,D1,E1,F1,G1,H1,I1:
I am looking for VBA script which would copy the text content in cells A1 through I1 and place it into cells A2 through I2 *in ASCII (hex)*, which would lead to the following output:
As soon as the content in cells A1 through I1 is changed, the script should change the content in row 2 as well. If A1 changes from 'the' to 'a', A2 should change from 007400680065 to 0061
Furthermore, I am looking for VBA-script that does the opposite, from ASCII (hex) to text:
In A1 I have the code string 00680065006C006C006F, in B1 I have the code string 0067006F006F0064006200790065
I am looking for VBA-script which would copy the ASCII (hex) code content in cells A1 and B1 and place it into cells A2 and B2 *in text*, which would lead to the following output:
As soon as the content in cells A1 and B1 is changed, the script should change the content in row 2 as well. If A1 changes from '00680065006C006C006F ' to '0067006F006F0064006200790065', B2 should change from 'hello' to 'goodbye'
Is it possible?
Thank you in advance for your help,
This question generated 13 answers. To proceed to the answers, click here.
This thread is current as of August 13, 2015.
For more resources for Microsoft Excel