textbox selection to relative row?
Hello I'm struggling with textbox selections. I have populated a textbox with vba code textbox.rowsource = "a3:a150" I would like to have this a little more flexible as i have 3 sheets i want to use it on and don't know what the 5th row from the bottom will end up in each sheet. i have seen the xlup statement but cannot figure it out. Also i would like to show the cell next to and 5th accross from the selected value from the list box to a textbox on the form. I am sure i have gone about this the wrong way, could someone give me a nudge in the right direction. Thankyou CAA ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
textbox selection to relative row?
Caa wrote:
textbox.rowsource = "a3:a150" I would like to have this a little more flexible as i have 3 sheets i want to use it on and don't know what the 5th row from the bottom will end up in each sheet. i have seen the xlup statement but cannot figure it out. A bit confused as a TextBox doesn't have a RowSource. Do you mean a ListBox? If so, try MyListBox.RowSource = Range(Cells(3,"A"), _ Cells(Rows.Count,"A").End(xlUp)).Address Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
All times are GMT +1. The time now is 05:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com