View Single Post
  #4  
Old November 29th, 2010, 09:22 AM
rekhasein rekhasein is offline
Banned
 
First recorded activity by OfficeFrustration: Nov 2010
Posts: 8
Default

Quote:
Originally Posted by Gord Dibben View Post
Private Sub Worksheet_Calculate()
On Error GoTo stoppit
Application.EnableEvents = False
With Me.Range("A1")
If .Value = "Desktop" Then
Sheets("Desktop").Select
ElseIf .Value = "Notebook" Then
Sheets("Notebook").Select
End If
End With
stoppit:
Application.EnableEvents = True
End Sub

Right-click on the sheet tab and "View Code". Copy/paste the code into that
sheet module.

Edit the "A1" to suit.

Alt + q to return to Excel.


Gord Dibben MS Excel MVP


On Sat, 5 Jun 2010 15:22:00 -0700, Phil
wrote:

I'm using the below formula to determine the specific type of equipment from
a list named: database

=IF(VLOOKUP($J$2,Database!$A:$U,21,FALSE)=$X$2,"De sktop",IF(VLOOKUP($J$2,Database!$A:$U,21,FALSE)=$X $5,"Notebook","Error!!!!!!!"))

value of X2 = DSK and value of X5 = NBK

What I need help with is a way of using the value returned to automatically
open the relevant worksheet, ie: If "Desktop" is returned the Desktop
worksheet needs to open and if "Notebook" is returned the notebook worksheet
needs to open automatically. All worksheets are in the same workbook.
I’m setting up several comment boxes and have a macro to automatically bring up the comments. However, I’m doing this in several cells and it’s become inconvenient to click on a different cell everytime I want to go to a new cell after typing in a comment box. Is there a way to get out of the comment box without using the mouse and/or clicking on another cell so I can go to another cell?