| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 134834 | 2013-08-21 00:14:00 | Excel VBA problem | Pierre777 (17141) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1351644 | 2013-08-21 00:14:00 | Hi all. I'm a newb here - having an issue with a form I'm setting up for work colleagues & I just can't figure out the problem, after googling it for days. Here's the issue - I have built a form that will display quite a lot of information in textboxes, based on a combobox selection. The data is sitting in columns on a worksheet - and I cant alter the format. It doesn't start on the top row/column, but 10 or so dorws down & the combobox is in the 2nd column. What I'm trying to display in the first textbox is the data in the column immediately to the left of the data that has been selected in the combobox i.e. combobox selects data from cell B11, I want the textbox to display the cell contents from cell A11. Any help, greatly appreciated. Cheers |
Pierre777 (17141) | ||
| 1351645 | 2013-08-24 07:03:00 | I'm a little rusty and this is probably dependant on how you're populating your combobox, but if you can determine the cell of the combobox value in the format Cell(x,y) then the code to fill the textbox would be Cell(x,y-1) So something like: Textbox.Value = Combobox.Cell(x,y-1) |
Antmannz (6583) | ||
| 1 | |||||