Help me please

D

darcus

hey all,

i had to write a program a while ago, actually in C, that is able t
convert for example a dec in hex or any other number in binary, hex
oct....now i am having problems with writing the same in VBA. it woul
be great if somebody could post a code of a small VBA program that ca
convert any numbers.
Heres the code of the C program, just to get you an idea of what i a
talking about. Sorry for my bad english but i am from austria.

thanks again, darcus

#include <stdio.h>

void main ()
{
/* Variable (Zeichen) definieren */
unsigned char cZeichen;
printf("\nBitte geben Sie ein beliebiges Zeichen ein: "); scanf("%c"
&cZeichen);
/* Anlegen einer Tabelle zur Umrechnung des eingegebenen Zeichens */
printf("\n-----------------------------------------------------------------");
printf("\n|\tASCII\t|\tDez.\t|\tHex.\t|\tOkt.\t|\n");
printf("\-----------------------------------------------------------------\n");
/* Berechnung des gesuchten Wertes für eingegebenes Zeichen */
printf("\|\t%c\t|", cZeichen); /* Ausgabe des oben eingegebene
Zeichens in ASCII */
printf("\t%d\t|", cZeichen); /* Ausgabe des eingegebenen Zeichens al
Dezimalzahl */
printf("\t%x\t|", cZeichen); /* Ausgabe des Zeichens als Hexadezimal
*/
printf("\t%o\t|\n", cZeichen); /* Ausgabe des Zeichens als Oktalzah
*/
printf("\-----------------------------------------------------------------\n");
 
P

Peter T

num = 123456789

sHex = Hex(num)
num2 = CLng("&H" & sHex)

sOct = Oct(num)
num3 = CLng("&0" & sOct)

MsgBox sHex & vbCr & num2 & vbCr & vbCr & vbCr & sOct & vbCr & num3

num4 = &HFFFFFF
MsgBox num4, , "&HFFFFFF"

num5 = &O123
MsgBox num5, , "Oct:123"

Regards,
Peter T
 
D

darcus

thank you very very much! but another question, is there a possibilit
to convert the entered number in a binary number? i was trying to fin
any function or so but didnt come up with anything....thanks again!

darcu
 
D

darcus

thank you very very much! but another question, is there a possibilit
to convert the entered number in a binary number? i was trying to fin
any function or so but didnt come up with anything....thanks again!

darcu
 
D

darcus

thank you very very much! but another question, is there a possibilit
to convert the entered number in a binary number? i was trying to fin
any function or so but didnt come up with anything....thanks again!

darcu
 
D

darcus

thank you very very much! but another question, is there a possibilit
to convert the entered number in a binary number? i was trying to fin
any function or so but didnt come up with anything....thanks again!

darcu
 
P

Peter T

to convert the entered number in a binary number?

Could you illustrate what you mean with an example of number entered and
what that should convert to.

Regards,
Peter T
 
Top