Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
I have a program working with Excel 2003 with VBA that uses the DEC2HEX
function within the VB routine (not in the Excel sheet) I have turned the Analysis and the Analysis VBA add-in on. I have also checked the atpvbaen.xls reference on in the VBA tools section. The Dec2Hex (and Hex2Dec) routines return sub or function not found error. The help section says it does exist.. However I am not able to use it. Any ideas on what can be done ? ----------- routine enclosed ------------- Private Sub CommandButton_ChangeSlaveAddress_Click() Dim SlaveAddress As Integer SlaveAddress = Hex2Dec(Range("SlaveAddressInput").value) If SlaveAddress < 0 Or SlaveAddress 255 Then MsgBox ("Invalid slave address entered!") Else Range("SlaveAddressInput").value = Dec2Hex(SlaveAddress, 2) End If End Sub -------------------------- Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
Paste EXCEL 2007 sheet into WORD 2007 - objects move around | Excel Discussion (Misc queries) | |||
Chart Selection - Excel 2007 copy to Powerpoint 2007 | Charts and Charting in Excel | |||
how to email excel 2007 worksheet with outlook 2007 | Excel Worksheet Functions | |||
Embedded Dec2hex help needed | Excel Worksheet Functions |