Ok, here's what I am trying to do.
I have a combo box EDIT*(In a UserForm)*EDIT that details numerous item names. I'm trying to return a value associated to the item in a textbox *in the same* user form.
I figure this can be accomplished like this:
search sheet for ComboBox1 value
return its location
offset (x,y)
return cell value to this static cell
Then I can tell the textbox to equal the static cell.
Perhaps I'm on the right track? Trouble is I'm not familiar with the codes to perform the aforementioned commands.
Now I'm wondering if it's even possible..
Maybe someone out there knows better? Happy to hear any thoughts !
Bookmarks