How to Add the Scroll Msg in excel sheet

[sgmpatnaik]

Hello sir,


i am very glad to meet you


i have some doubts in excel and VBA shell i


1. How to add the Scroll Msg in excel sheet


2. how to add the search box in excel between the two sheets

(I mean in sheet1 i add Column A Column B

1 Mr. Bond

2 Mr. James

3 Ms. Namita


now i would like to add the search box in sheet2


Search - Mr. Bond here i would like add the Button - Go


When i search for Mr. Bond and press go


then it will display in below of sheet 1 both Column A and Column B


Kindly suggest

 

[SirJB7]

Hi, sgmpatnaik!


Perhaps you'd want to read the three green sticky posts at this forums main page so as to know the guidelines that will lead to know how this community operates (introducing yourself, posting files, netiquette rules, and so on).


And about your question, I'm afraid I'm unable to understand what you want. What are you referring to with "Scroll Msg"?


Would you please elaborate a bit more or upload an example file? Give a look at the second green sticky post at this forums main page for uploading guidelines.


Regards!

 

[senthilkumar_rm]

Hi


Iam Sure I don't understand, Moreover please be elaborate or upload ur workbook for getting assistance


For Your Q,


Scroll bar and Option button can be added using control tool box


Senthilkumar_rm

 

[sgmpatnaik]

I am extremely sorry sir


actually i am doing some accounting works in excel for my office use.


i create one Work Book and there is Sheet1, Sheet2, Sheet3, Sheet4 as like


in Sheet 1 i create some forms with macro option for sheet2 to Sheet 4 and more (for your information i hide the all sheets with macro option except Sheet 1) when i press the forms in Sheet1 then the hidden sheet is Displaying.


now i am trying to add the AUTO SCROLL TEXT MSG IN SHEET 1 RANGE FROM A1 TO O1 AND O1 TO A1


THE TEXT IS AUTO SCROLL WHEN THE WORK BOOK IS OPEN AS LIKE THE AUTO_OPEN () THIS IS MY 1ST QUESTION


IF YOU STILL CONFUSE WITH MY QUESTION THEN PLEASE SUGGEST ME HOW TO ATTACH MY WORK BOOK FOR YOUR INFORMATION


Kindly solve my problem and give me a good suggestion hence i oblige


waiting for your replay


Thanking you

 

[NARAYANK991]

Hi Patnaik ,


Check out the details here , on how to upload your workbook(s) :


http://chandoo.org/forums/topic/posting-a-sample-workbook


Narayan

 

[sgmpatnaik]

Sir,


Given below link for my example work book kindly check and suggest me


Thanking You


http://dl.dropbox.com/u/75654703/index.xls

 

[NARAYANK991]

Hi Patnaik ,


What you are asking for is to develop code to fulfill your requirements ; I hope someone else can help you out.


As far as the scrolling message is concerned , the following link has the solution , developed by Andy Pope :


http://www.ozgrid.com/forum/showthread.php?t=41046&highlight=marquee


Narayan

 

[sgmpatnaik]

Here is one error msg why this shows


and when i share the work book it is very slow to open why?


pls suggest


https://www.dropbox.com/sh/wu2txjinvyy2qxq/mo2Mxt9A5x/Error.png

 

[NARAYANK991]

Hi Patnaik ,


The picture you have uploaded does not really give any idea of what the problem is ; however , can you indicate what version of Excel you are using , and how you are trying to save the workbook ? If you are trying to save it as a .xls workbook , compatible with Excel '97 - 2003 , it is possible the error may be due to this. Try saving it as .xlsx if you have Excel 2007 or later.


Narayan

 

[Hui]

Sgmpatnaik


As suggested above, please read the 3 sticky Green posts on the main Chandoo.org Forum window


You have already posted this question here: http://chandoo.org/forums/topic/auto_open


This is called cross or Multi Posting and is generally frowned upon in the Blogosphere as it causes people to potentially waste our time when a question is already answered.


You should also check and respond to posts and let posters know if they are heading in the write direction or not. </Rant>