Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


share|improve this question

migrated from Oct 22 '10 at 11:26

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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .