Re: Sum from texboxes at the end of userform
Hey Roy
Coudl you explain this line more clearly?
this clng and other options.
And one more thing.
What textbox feat should l use to entered into texboxes values be added to sheet?
Re: Sum from texboxes at the end of userform
Hey Roy
Coudl you explain this line more clearly?
this clng and other options.
And one more thing.
What textbox feat should l use to entered into texboxes values be added to sheet?
Got user from
some texboxes to put quantities and prices in it.
Want a summing texbox or label or whatever to showing me the sum of textboxes values
Any help will be highly appreciated.
Re: Hyperlink in msgbox
can not get this to work even with this set target = range
need more reading and practice
but thanks for help.
Re: Hyperlink in msgbox
i received an e-mail that you replied in this thread but cant find the answer here
Re: VBA changes on another sheet
Thanks ROY. I was viewing this page. Unfortunatly VBA section is paid.
So the whole problem is putting it in another line and deleting the .Value
THANK YOU GUYS.
BTW: Roy - is there a help chance with this showing userform with cell walues changing in column?
Hello!
I think it is lame question but:
with two optionbuttons on one sheet i want VBA to add value on another sheet depending on optionbutton status.
So
Private Sub OptionButton1_Click()
If OptionButton1.Value = True Then [B][U]Sheets("Arkusz3").Range("c6") = OK[/U][/B]End Sub
got problem with proper name of range on another sheet.
BTW: where can i find some free vba basic introduction for very very begginers over the net?
Re: Hyperlink in msgbox
thank you Roy.
with sigle cell selection it works perfect.
How can i change that to check whole column for 3 different text enters?
Column is AC for example and i need the user form to be shown while value change from empty cell to web, site and app.
Could you help me?
Re: Hyperlink in msgbox
this making of user from thing is the easiest part.
what about showing it when correct value in the cell?
text value like "SHOP"
EDIT: sorry missed your previous post.
DAMN i m too stupid for that
Re: Hyperlink in msgbox
any advise how to call it?
i m thinking like
Sub H_MsgBox()
Dim oShell As Object
Dim iResponse As Integer
Set oShell = CreateObject("Wscript.Shell")
If Range("a1").Value = "text" Then
iResponse = MsgBox("Would you like to apply for access to this resource?", _
vbYesNo, "Access Denied")
Else
If iResponse = vbYes Then
oShell.Run ("http://www.excrl-it.com")
Else
Exit Sub
End If
End Sub
Display More
my knowledge is rather small
Re: Hyperlink in msgbox
it works fine but what i want (and what i have seen) was
msg box with text which i was able to klick and then it was hyperlinked
like PLEASE CHOOSE ONE:
www.
www.
www.
and this is waht i want. someone is entering value like SHOP it a cell an it can choose from popup msg box and www adreess
can someone help me?
EDIT
this one als could work for me but i dont have enough knowledge to change it.
waht i need is im putting shop in cell and the vba code with this msg box is on : do you want to be redirected to this web site YES NO and correct web is added.
Re: Hyperlink in msgbox
once i found vba example of adding hyperlinks to msgboxes. Right now dont know where but it was possible.
Re: Add a calendar to right click
Hello!
New here. From Poland.
Got one calendar but always was looking for the one under right click.
Cant run the one is able to download.
Is there a new version?
Thanks in advance.