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.