Search:

Type: Posts; User: ricardodiazjimenez; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: If Chip Pearson's website ever helped you, please jot a note...

    Thanks for being such a source of knowledge and inspiration.

    RIP Chip
  2. Re: Check In a Workbook Without Closing

    I stumbled upon this situation too.

    What I ended up doing was:

    1) Create a global variable to check if the closing event came from the CheckIn at the top of a module:


    Global...
  3. Re: Queries and Connections Pane via VBA?

    This is what I get
    http://ricardodiaz.co/personal/ExcelQueriesPane.jpg
  4. Replies
    2
    Views
    145

    Re: Archive from a table

    Hi, in what line you get the error?
  5. Replies
    2
    Views
    184

    Re: Basic userform problem

    Hi,

    Maybe if you put a screenshot of the current form design it'd be easier to help you out.
  6. Re: Find and Replace across multiple rows and sheets

    Hi,
    You can try to put the formula in Sheet 2 cell B1: = Vlookup(A1;'Sheet 2'!$A$1:$B$12;2;FALSE) and copy it to the cells below.
  7. Re: Can't get both codes to work when both are active

    Hi,

    this should get you started.



    Private Sub Worksheet_Change(ByVal Target As Range)


    ' Check if more than one cell is affected
  8. Replies
    1
    Views
    123

    Re: Textbox Value to Double

    Try this:



    Dim MNLActualPerf As Double

    txtMNLActualPerf.Text = "11.15%"


    If InStr(Me.txtMNLActualPerf, "%") > 0 Then
  9. Re: Queries and Connections Pane via VBA?

    Thank you Matt, did you manage to find whats the new commandbar name?
  10. Re: Queries and Connections Pane via VBA?

    Hi, I'm using Excel 1807 (compilation 10325.20082) and when I use this code the pane opens, but is blank (used to work before). Does anybody know if there is something to be changed? anybody else...
Results 1 to 10 of 10