If it ain't broke don't fix it?

[medeardorff]

I had created a couple of hundred XLM functions in the OLD days when that was the paradigm prior to VBA. I am a structural engineer and I automated my office with spreadsheets that optimized designs, did nice formatting using the arcana of XLM. It was quite a skill; but no more.

Now I am converting them to VBA, A language I programmed in as VB6 and earlier.

The first issue I am having is getting around the #NAME error I am receiving. The UDF is in a standard module. The code is shown below.

Option Explicit
Option Base 1

Function DecFtToIntFt(Ft As Long) As Integer
DecFtToIntFt = Int(Ft)
End Function

Here I am just returning the integer portion of a decimal representation of a foot measurement to be rendered as part of a dimension string. Unfortunately, I get a #NAME error.

 

[Fluff]

Is the UDF in the workbook you are trying to use it in?

 

[medeardorff]

Is the UDF in the workbook you are trying to use it in?

Yes, for now, to get it working. Ultimately in Personal.

 

[Fluff]

In that case don't use the workbook or module name, it should just be

=DecFtToIntFt(N53)

 

[medeardorff]

In that case don't use the workbook or module name, it should just be

=DecFtToIntFt(N53)

No change

 

[Fluff]

In that case check that macros are enabled.

 

[medeardorff]

Is that in the Trust Center? I enabled VBA macros. Still no change. It must be simple.

 

[medeardorff]

Is that in the Trust Center? I enabled VBA macros. Still no change. It must be simple.

I reopened the workbook; the macro ran properly after that. Now I must properly sign these so that I can send these out to others when I sell them.

Thank you for your help. Saved me a bunch and taught me information I will not forget.

 

[Fluff]

Glad you sorted it & thanks for the feedback.