Results 1 to 31 of 31

Position dialog box on current sheet

Threaded View

DairyQueen Position dialog box on... 02-03-2020, 12:56 PM
DairyQueen Re: Position dialog box on... 02-03-2020, 02:12 PM
BMV Re: Position dialog box on... 02-03-2020, 02:18 PM
DairyQueen Re: Position dialog box on... 02-03-2020, 03:48 PM
jolivanes Re: Position dialog box on... 02-03-2020, 04:04 PM
DairyQueen Re: Position dialog box on... 02-03-2020, 04:11 PM
Leith Ross Re: Position dialog box on... 02-03-2020, 04:33 PM
DairyQueen Re: Position dialog box on... 02-03-2020, 04:44 PM
DairyQueen Re: Position dialog box on... 02-04-2020, 11:10 AM
Andy Pope Re: Position dialog box on... 02-04-2020, 11:43 AM
DairyQueen Re: Position dialog box on... 02-04-2020, 01:47 PM
BMV Re: Position dialog box on... 02-04-2020, 02:20 PM
Andy Pope Re: Position dialog box on... 02-05-2020, 04:29 AM
BMV Re: Position dialog box on... 02-05-2020, 04:45 AM
zzzeddy Re: Position dialog box on... 02-05-2020, 09:58 AM
BMV Re: Position dialog box on... 02-05-2020, 11:27 AM
zzzeddy Re: Position dialog box on... 02-05-2020, 12:42 PM
DairyQueen Re: Position dialog box on... 02-05-2020, 01:28 PM
zzzeddy Re: Position dialog box on... 02-05-2020, 01:36 PM
DairyQueen Re: Position dialog box on... 02-05-2020, 01:39 PM
zzzeddy Re: Position dialog box on... 02-05-2020, 01:40 PM
zzzeddy Re: Position dialog box on... 02-05-2020, 01:49 PM
DairyQueen Re: Position dialog box on... 02-05-2020, 01:51 PM
zzzeddy Re: Position dialog box on... 02-05-2020, 01:59 PM
zzzeddy Re: Position dialog box on... 02-05-2020, 02:02 PM
DairyQueen Re: Position dialog box on... 02-05-2020, 02:46 PM
zzzeddy Re: Position dialog box on... 02-05-2020, 04:24 PM
BMV Re: Position dialog box on... 02-05-2020, 03:23 PM
zzzeddy Re: Position dialog box on... 02-05-2020, 03:26 PM
BMV Re: Position dialog box on... 02-05-2020, 03:40 PM
zzzeddy Re: Position dialog box on... 02-05-2020, 04:22 PM
  1. #1
    Registered User
    Join Date
    07-24-2015
    Location
    Puget Sound, Washington State, USA
    MS-Off Ver
    MS Office 2016
    Posts
    15

    Question Position dialog box on current sheet

    First, a grateful thank you to all the helpful people who generate online help for Excel users.

    Right now, I want to combine two very nice vba suggestions but don't know where to put the position instruction inside the VBA for the CalcWhat. This doesn't work, or anything else I can think of to try:
    Sub CalcWhat()
        Dim iAnsure As Integer
    
        Application.Calculation = xlManual
        iAnsure = InputBox("1 = Calculate A Used Range" _
          & vbCrLf & _
          "2 = Calculate This Worksheet" _
          & vbCrLf & _
          "3 = Calculate This Workbook" _
          & vbCrLf & _
          "4 = Calculate All Workbooks in Memory" _
          & vbCrLf & vbCrLf & _
          "Input Your Selection Number From Above" _
          & vbCrLf & "Then Click OK", _
          "Calculate What?", "Input Number Please", _
          5000, 5000)
    
    CalcWhat.StartUpPosition = 0
    CalcWhat.Top = Application.Top + 25
    CalcWhat.Left = Application.Left + 25
    CalcWhat.Show
    
        Select Case iAnsure
            Case 1 'Range Only
                Selection.Calculate
            Case 2 'Worksheet Only
                ActiveSheet.Calculate
            Case 3 'Workbook Only
                For Each wks In ActiveWorkbook.Worksheets
                    wks.Calculate
                Next
            Case 4 'All Open Workbooks
                Application.CalculateFull
            End
        End Select
    End Sub
    Thank you in advance for your help.

    "Slow but willing new VBA learner"
    Last edited by DairyQueen; 02-03-2020 at 06:25 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Built-in Dialog screen position
    By kev_ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2018, 04:33 AM
  2. .checkspelling dialog box screen position
    By BellyGas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2017, 05:03 AM
  3. [SOLVED] calculate current position
    By Patcheen in forum Excel General
    Replies: 11
    Last Post: 02-28-2015, 06:25 PM
  4. Current cell position for a non Active worksheet
    By Wizz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-15-2009, 08:40 PM
  5. Replies: 7
    Last Post: 02-02-2009, 02:40 PM
  6. [SOLVED] How do you set cursor position at current date in macro?
    By Tom Robertson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-28-2006, 10:55 AM
  7. [SOLVED] Current cell position
    By AJPendragon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-03-2006, 12:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1