Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

i have made a flow chart diagram in an excel sheet using TextBox tool from drawing toolbar.
i've made entries into the text boxes.(No other data is present in the cells of the worksheet)

But now when i search for a particular text in the sheet, it is not showing up. im unable to locate the text using CNTRL+F option, and im forced to go through each TextBox manually for the required text.

One way i have is that, instead of using TextBoxes I can directly enter the text into the cells, but doing this will restrict my requirement(as i have used the cell's width as interval and the TextBox width as the time for which the task will happen).

Is there any way to make sure that the text in the TextBox can be identified when searched using CNTRL+F option or is there any other way to draw a flow chart so that the text can be found when searched.

Help me out in sorting this out.

Thanks.

share|improve this question
add comment

migrated from stackoverflow.com Oct 22 '10 at 11:26

This question came from our site for professional and enthusiast programmers.

1 Answer

Got a clue...
I've gave a keyword(that will distinguish the TextBox in interest from others) of the text in the TextBox in a cell and made the cell as hyperlink to the nearest cell where the TextBox with the related text is present.

So, when i search for a text(keyword) using CNTRL+F then this takes me to the cell(in which the keyword is present) and when i click the cell(hyperlink).. it takes me to the cell nearest to the related TextBox. ..Hope this works fine if the TextBoxes have a unique word(s) to distinguish them from one another.

share|improve this answer
    
Would invite other thoughts which would work better... –  Identifymecnu Jan 29 '10 at 15:49
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.