Re: Working on spreadsheet control in userform
What do you mean by your 'Note' line? (The Spreadsheet control is not included in Office 2007 or later)
Re: Working on spreadsheet control in userform
What do you mean by your 'Note' line? (The Spreadsheet control is not included in Office 2007 or later)
Re: Use a textbox's value directly in cell formula
You could use the LinkedCell property of the textboxes to enter the values into the worksheet, but they would come through as text so you would have to convert them to numbers in your formula. I can't imagine a good reason for this though.
Re: user form textbox issue
For future reference, if you are going to cross-post in several forums (which I just noticed), you are likely to get in trouble in most of them if you don't provide links to the other posts!
Re: user form textbox issue
You need the Userform_Initialize or Activate events, not the Textbox_Change event which is only triggered by you changing the text box.
Re: find path within formula and replace
Do you have any of the options such as 'match entire cell' checked in the find dialog?
Re: OFFSET - ignore any N/A's in named range
Sorry, I assumed you already had a dynamic range using COUNT or COUNTA. The formula you want is:
=OFFSET(Sheet1!$A$1,0,0,COUNTIF(Sheet1!$A$1:$A$24,"<>#N/A"),3)
See attached demo.
Re: OFFSET - ignore any N/A's in named range
If you don't have any blanks in the data that you need excluded, you could just use COUNTIF(range,"<>#N/A")
Re: OFFSET - ignore any N/A's in named range
Are the #N/As within the actual data, or below the last 'valid' entry?
Re: use button name and relative location in a macro
You're welcome.
Re: find path within formula and replace
Yes, but we didn't know you were doing multiple files from the same location initially.
What have you selected when you are using the Find/Replace dialog? If it's more than one cell, then the search only takes place in the selected cells.
Re: use button name and relative location in a macro
You need to use Application.Caller, as I said earlier.
Re: Look up value in other workbook and return result from offset row
Use INDEX and MATCH instead of VLOOKUP:
=INDEX('[book2.xls]Sheet1'!E1:E100,match(A2,'[book2.xls]Sheet1'!A1:A100,0)+3)
for example.
Re: use button name and relative location in a macro
I suspect that you had paused code elsewhere and couldn't therefore run the code. Clearing the code out would cause a reset of the paused code too.
Re: use button name and relative location in a macro
That means that you already have code running when you try to run that. How are you running it?
Re: use button name and relative location in a macro
The Msgbox is just a demonstration of how to get the address of the clicked button. What you actually do with the information is up to you!