I am trying to use the InputBox function to automatically edit a number of cells with a similar file link. The file path remains constant but the file name changes in each case, by a 10 digit project number. I figure the best way would have the user input the project number into an input box and the response used with the replace function to amend the link. I'm also a bit of a Visual Basic novice.
4 1214
Which cells are you editing? Is it in Excel or any other grid control?
It is in Excel. The formula is similar to the one below which relates to about 9 different groups of cells.
=IF(OR('J:\SHARED\General_Services_Shared\DESIGN & CONSTRUCTION\Capital Projects Admin\REPORTS\Latest Reports\[Latest report 1200006013.xls]Full Report'!$H$19="r",'J:\SHARED\General_Services_Shar ed\DESIGN & CONSTRUCTION\Capital Projects Admin\REPORTS\Latest Reports\[Latest report 1200006013.xls]Full Report'!$H$20="r"),"R",IF(OR('J:\SHARED\General_Se rvices_Shared\DESIGN & CONSTRUCTION\Capital Projects Admin\REPORTS\Latest Reports\[Latest report 1200006013.xls]Full Report'!$H$19="a",'J:\SHARED\General_Services_Shar ed\DESIGN & CONSTRUCTION\Capital Projects Admin\REPORTS\Latest Reports\[Latest report 1200006013.xls]Full Report'!$H$20="a"),"A","G"))
Sorry to see you're not getting much of a response on this. I guess things get pretty quiet over Christmas.
I think probably the simplest thing would be to write a function to do what you want, then just use that function in the formula. For instance the cell could just say something like: =MyFunction()
The function, written in VBA, can prompt the user to enter the number, then open the appropriate worksheet, check the appropriate values, make decisions, and return the appropriate value.
When I have time, I'll try to help you with the code for the function if you like.
Thanks Killer42. That would be brilliant.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Pea |
last post by:
Hello,
I have a nicely running report (thanks to Reggie and others) which
I've been asked to modify to prompt for the Month (a monthly report to
be run). I used an InputBox command:
...
|
by: GB |
last post by:
Hello:
Is it possible to make formatting of MsgBox and InputBox in sence of fonts,
size, etc. ?
Thanks,
GB
|
by: peter.staab |
last post by:
I have been trying to do the following. Using JS I want to create an
input element (text box) and attach a event listener. I have done in
in two different ways. The first is using xml elements...
|
by: jpoquette |
last post by:
I have recently upgraded a Visual Basic 2003 win forms application to
2005. After doing so I can no longer get my project to compile. The
code is bombing on any line that uses an InputBox. I'm...
|
by: Aaron West |
last post by:
Try this script to see what queries are taking over a second.
To get some real output, you need a long-running query. Here's one
(estimated to take over an hour):
PRINT GETDATE()
select...
|
by: solinear |
last post by:
OK, I am going to preface this by saying I'm very new to VB coding (or any other kind, for that matter), but know a lot about Windows, AD and Security. We are making adjustments to our environment...
|
by: =?Utf-8?B?YzY3NjIyOA==?= |
last post by:
Hi All,
Our company is merging two production domains(from two different servers)
onto one server. So during the migration we use an intranet testing server to
hold all files from these two...
|
by: Constantine AI |
last post by:
Hi I am currently using an inputbox to input a csv filepath location, as this is a lengthy task and not really good for novice users to use and know of, is it possible to use the windows exlorer.exe...
|
by: Intos |
last post by:
Hi.
How to change the text of inputbox if i have already set the style for
something else?
In other words:
<input name="fItem" type="text" id="fItem" style="border:hidden" size="80"...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |