If this is your first visit, then welcome! Be sure to
check out the FAQ by clicking the
link above.Register here
so that you can post in the forums or comment on the articles.
I recommend you to review this tutorial (it is about dependent combo boxes - creating dynamic range names) :
I'll give it a try.
Is it possible to show all relevant data in scenario:
1. Pick a value from combobox1
2. Form will...
Use Val() to convert a numeric string to a numeric.
ff.Value = Val(TextBox5)
I have a template that once opened as a new worksheet asks the user to provide the path to their SharePoint document library - the workbook should then...
This all sounds a bit complicated, but I get the idea in general. Bearing in mind that you aren't providing a sample workbook, this makes...