Title kind of explains the question. I'm trying to format a column of cells for the input of Mac Addresses so I don't have to put in the : after each set of numbers/letters i.e. 12:34:5B:6D:78:9F.
Any help in this matter would be greatly appreciated, and if this solution is very simple I do apologize
Last edited by VBA Noob; 11-30-2007 at 12:54 PM.
I've tried 00":"00":"00":"00":"00":"00 and ??":"??":"??":"??":"??":"?? and also with ##'s which work fantastic for numeric addresses, but fails to put in the : : : : when you add in the alphanumeric portion of the address
Hello Axis ,
Here is a macro that returns both the IP address and MAC address for the NIC installed on your computer. The information is displayed in dialog box in normal address format.
[code]Adding the Macro
Please Login or Register to view this content.
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel
To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.
Sincerely,
Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks