to avoid typing in combobox
On Thu, Oct 3, 2013 at 12:27 AM, Bipin Singh wrote:
> Hello Ashish,
>
> May I ask you the use of ComboBox1_KeyDown and ComboBox1_KeyPress event in
> provided solution if *Userform.show* is already inside worksheet change
> event..
>
> Thanks in advance.
>
> Thanks,
>
Hello Ashish,
May I ask you the use of ComboBox1_KeyDown and ComboBox1_KeyPress event in
provided solution if *Userform.show* is already inside worksheet change
event..
Thanks in advance.
Thanks,
Regards,
BS
On Wed, Oct 2, 2013 at 12:41 PM, ashish koul wrote:
> try attached file
>
>
>
> On
Brilliant mate. Works very well.
On Wednesday, October 2, 2013 3:11:27 PM UTC+8, ashish wrote:
>
> try attached file
>
>
> On Wed, Oct 2, 2013 at 12:01 PM, Jewel Sharma
> > wrote:
>
>> Hi Ashish,
>> This is great, but doesn't meet my need. Allow me to explain:
>>
>> The workbook will have certain
try attached file
On Wed, Oct 2, 2013 at 12:01 PM, Jewel Sharma wrote:
> Hi Ashish,
> This is great, but doesn't meet my need. Allow me to explain:
>
> The workbook will have certain "hidden" sheets that the user does not need
> to interact with. That is why I'm hiding the *.* So, I need a
> "N
Hi Ashish,
This is great, but doesn't meet my need. Allow me to explain:
The workbook will have certain "hidden" sheets that the user does not need
to interact with. That is why I'm hiding the *.* So, I need a
"Navigation Pane" that would allow the user to move only to the 8
worksheets where th
Also if u want to add worksheet navigation button on right click try this
*Add below code to workbook open module*
Private Sub Workbook_Open()
On Error Resume Next
'Delete the new button if already exists
' name of the new button is "New Button"
Application.CommandBars("Cell").Co
try this
Sub test()
Application.CommandBars("Workbook tabs").ShowPopup
End Sub
On Wed, Oct 2, 2013 at 11:26 AM, Jewel Sharma wrote:
> Hi,
> I have a workbook with 8 worksheets; wherein I anticipate the user would
> move to and fro between them in the course of using the workbook. To
> simplif
Hi,
I have a workbook with 8 worksheets; wherein I anticipate the user would
move to and fro between them in the course of using the workbook. To
simplify navigation, I intend to do the following:
1. Create a Userform that has labels for all worksheets.
2. Such userform should be always vi
