noob question

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

noob question

Logged in as: Guest

arrSession:exec spGetSession 2,2,61864

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> noob question
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

noob question - 6/25/2008 10:55:18 AM

gabester

Posts: 1
Score: 0
Joined: 6/25/2008
Status: offline

Hi guys,

This is my first time on VBScript, I have a noob question and hope that you can help me. I have scripted in other packages before like php mysql, and Mel.

1. How do I execute a VB script in Microsoft Excell?

2. Where do I go to get command reference? In mel script I had a whole library, in VB I can't find any libraries.

3. I have a scenario, and if any of you could please take the time to write me a reply, it'll definitely help me to understand the software:

   In Excel, I want to execute a vb script through a macro. This script should:

   1. Check the cell number that the user is on, put it in a variable

   2. Search the same field of cells, in this case B, and substitute the word "_right_" with the word "_Left_" of the entire cell. If it finds it, it should put the
    cell location of the found cell into another variable. So if I have a cell with the word: animation_turn_Right_new, it should look for an animation called         animation_turn_Left_new.

   3. It should change the text in both cells to hyperlink each other. So that when I click one, the other one, the corresponding other highlights. The hyperlink code is as follows: =HYPERLINK("#"&CELL("address",B95),"BC_StandTackled_Left_Legs_ToGround_Facedown")

Any help would be greatly appreciated

-Gabe

Post #: 1

RE: noob question - 6/26/2008 12:24:33 AM

ebgreen

Posts: 5041
Score: 31
Joined: 7/12/2005
Status: offline

Read the "Read Me First" post that is pinned at the top of this forum. Also read the "Frequently Asked Stuff" thread.

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to gabester)