LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Javascript funchtion converting to Excel

Anton,
Add a module to an Excel project, then you can make into a function, passing
the number (or 2 numbers, I'm sure how you implementation works) and return
a string or Boolean. e.g.

Public function TestID (ID1 as string) as String
'etc
ID=ID1
'etc...
If base < Tmpr Then
TestID = "You must enter 11 number for ID (0 - 9) "
ElseIf (i = TmpStr) And (y = TmpStr2) Then
TestID = "Thanks for right ID no."
Else
TestID = "Wrong ID no."
End If

End function

call it from a worksheet with:
=TestID(A1)

Depends where vekt1& vekt2 are coming from.

NickHK

"ANton Petrov" wrote in message
...
where should i copy this code in Excel?
Thanks :)



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to enable javascript in Excel? CC Excel Programming 1 August 17th 06 09:46 PM
Sumis funchtion and offset function vivi Excel Programming 3 August 4th 06 12:51 AM
Help: Javascript to Excel VBA? Ron J Excel Programming 3 April 6th 06 03:28 AM
Converting a row or column in excel to a Javascript array ncikusa Excel Discussion (Misc queries) 0 April 4th 06 10:04 PM
Possible to write Excel macros in JavaScript? Christopher M. Balz Excel Programming 0 December 16th 03 10:27 PM


All times are GMT +1. The time now is 08:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"