User`s guide

3 Usage Examples
bPlot = chkPlot.Value
'Compute the fft and optionally plot power spectral density
If bPlot Then
Call theFourier.plotfft(3, theFFTData, Frequency, PowerSpect, _
InputData, Interval)
Else
Call theFourier.computefft(3, theFFTData, Frequency, PowerSpect, _
InputData, Interval)
End If
GoTo Exit_Form
Handle_Error:
MsgBox (Err.Description)
Exit_Form:
Unload Me
End Sub
Adding the Spectral Analysis Menu Item to Excel
The last step in the integration process adds a menu item to Excel so that
you can open the tool from the Excel Tools menu. To do this you add event
handlers for the workbook’s
AddinInstall and AddinUninstall events that
install and uninstall menu items. The menu item calls the
LoadFourier
function in the FourierMain module.
Follow these steps to implement the menu ite m:
1 Right-click the ThisWorkbook item in the VBA project window and click
View Code.
3-24