Hi,
When entering data in a combobox is there a way to 'jump' to the next combobox the same way if i were in cell A1 to 'jump' to cell A2 by pressing 'enter' ?
Hi,
When entering data in a combobox is there a way to 'jump' to the next combobox the same way if i were in cell A1 to 'jump' to cell A2 by pressing 'enter' ?
try using tab instead of enter, otherwise, you may have to use that pointer/clicker thingy .
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
C'mon...
Is there another way of autofilling my entry in a cell other then a combobox?
Something like 'google search that autofills your query
Sorry hqradio, my attempt at humour was partly based on my vague understanding of what you need. Try using code likeLet me know if you need more assistance.Please Login or Register to view this content.
Not @ computer now but I will sure check the second I get there.....
I don't know at the moment if the code I gave you will work as I didn't use ActiveX comboboxes but I will give it a go now.
Please excuse my code as it does not apply to sheet side comboboxes. I will send this on to the gurus that will know definitively whether or not this can be accomplished. As it is with what I was trying to do, it wouldn't work as per your requirements.
is there a code that when i change a certain cell (eg A1) that when i press 'enter' it should jump to a different cell (eg B22)??
any help would be greatly appreciated
Hi hqradio
If you're working with thistry this codewhen i change a certain cell (eg A1) that when i press 'enter' it should jump to a different cell (eg B22If you're working with thisPlease Login or Register to view this content.
try this codeWhen entering data in a combobox is there a way to 'jump' to the next combobox the same way if i were in cell A1 to 'jump' to cell A2 by pressing 'enter'In either case the code will go in the sheet module.Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
this works great, but can i use this a couple of times in one sheet at different cells?try this code
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Target.Address = "$A$1" Then
Exit Sub
Else
Range("B22").Activate
End If
End Sub
this works great but it jumps to the next combobox even when i change 1 letter, i use a list of items and i want it to change only when i press "enter"
also as i said i use a list of items in the combobox, why do i only see 1 column of my items? why cant i see (in the combobox) all columns of my list?
Hi hqradio
There's several ways to do thishere's but onecan i use this a couple of times in one sheet at different cellsRegarding the ComboBox approach, there's an example of how to do thisPlease Login or Register to view this content.
at this linkhttp://www.contextures.com/xldataval10.html#Propertiesi use a list of items and i want it to change only when i press "enter"
To deal with thisyou need to change the ComboBox ColumnCount Property.in the combobox, why do i only see 1 column of my items
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks