Posts by schimmey

Hi Dave,
Thanks, works perfectly.
In a smiler manner is it possible, rather than return the number of days, return a drop down list? Say my named range is "Names".
Thanks.
Kind regards,
Paul

Good afternoon all,

I have 3 columns (actually more but making this easy to explain). The first 2 columns (A and B) are dates. The 3rd (C) is a formula to calculate the number of days between the two dates. I have multiple rows which means that I have to drag the formula down or populate it in column C before I enter (future) dates (this is a continually expanding list). Is there a way I can use vba to automatically populate the respective cell in Column C when columns A and B (of the same row) are completed?

Thanks.

Kind regards,

Paul

Hi All,
I have a userform that at present retrieves cell data via vlookup. My question is whether it is possible to 'point' the vba userform module to coding stored in a cell in a worksheet?
Thanks, Paul

Re: making use of modules?

Hi Grimes,
Thanks for that. Now I know why when I tried it they did not appear to work as they were all userform related.
Paul

Hi,
I have a userform that contains quite a few Function procedures. Rather than have these contained within the userform code how do I go about putting these neatly into a module to then call on?
Thanks.
Kind regards,
Paul

Re: rescale all controls and userform in via editor

Thanks guys for your help. I will let you know how it goes. Paul

Hi All,
I have been using label boxes show information retrieved so as to stop the user changing any of the return text. However the return text is quite large. There is no scrollbar option for labels but there is for text box but if I set the enable property for the text box to false the scrollbars disappear. Is there anyway I can stop this from happening?
Thanks. Paul

Re: rescale all controls and userform in via editor

Hi Carim,

Thanks for that. I am trying to find a way of rescaling it in vba editor itself rather than go through resizing each one. Much appreciated.

Paul

Hi All,
Is it possible to resize all elements within a userform to make them proportionately smaller?
Paul

Re: setting a reference value in vba

Think I have sorted it. I have created a function to calculate the 1st vlookup. It seems to work well.

Re: setting a reference value in vba

Here is the code I am trying to use:

Private Sub cbxArticleNo_Change()


Dim iLink As Integer




        iLink = Application.WorksheetFunction.VLookup(Me.cbxArticleNo, Range("vlookupURN"), 2, 0).Value
        
        Me.lbTFAArticleSubheading = Application.WorksheetFunction.VLookup(iLink, Range("vlookupWTO"), 3, 0)


End Sub

Hi All,

I need to put a vlookup function within a vlookup function. Rather than make this messy I want to 'set' the 1st and name it vlink and then refer to this within the 2nd. I have looked at Dim and Set but have not been successful. How can I set the result of the first to then be used as the lookup value for the 2nd?

Thanks.

Paul

Re: vba to automatically resize user form depending on screen resolution

Hi Grimes0332,
Thanks. I would like it to fit comfortably within the screen size rather than application as I intend to reduce excel when the user form is initialised. I tried the code above but it creates s small box in the middle of the screen. I can see where you are coming from through.
Paul

Hi All,

This appears to be a common question but I cannot find an early clear answer that makes sense.

I have a user form that will be used by different users with different screen resolutions. My question is how do I code so that when the user form is initialised:

1) the user form defaults to the centre of the excel application window,
2) sizes so that it is 15% smaller by height and width of the excel application window?

Thanks.

Paul

Re: maintain text style in user form

Thanks. I thought as much but wanted to check. Appreciated.

Hi All,
I have a user form that populates various labels with text using lookup to a spreadsheet. The target cell in the spreadsheet has been styled (e.g. bold for heading). Is it possible to maintain this so that the style is exactly the same in the label box?
Thanks.
Paul

Re: excel for Mac 2015 cannot find forms etc in vba

Hi Ger,
Thanks for that. You have answered my question. Kind regards,
Paul

Hi All,
I have just downloaded the above but cannot find in vba forms etc. Any advice?
Paul

Re: excel formula to populate comment box or input message

Hi Luke,
Sorry about this but my mind is blank. I tried your code but could only get a comment box to appear with no text. I tried to figure things out but no luck. I have attached a redacted example. What I want is when I hover over or select a cell in Sheet1 D2 a comments box will appear that will contain the text in Sheet2 C2 using Article No. as the lookup value using vlookup. The same for D3/C3 and so on (there are about 50 rows).
Any ideas?
Paul
forum.ozgrid.com/index.php?attachment/68069/

Re: excel formula to populate comment box or input message

Hi Luke,
Thanks. It has been a while since I did any vba. Can you give me any pointers?
Paul